MSSQL:Unable to connect to server:xxx:MSG 18452:login failed

[tamugrg13]

Hi,

I am new to Microsoft SQL server database. (have used other dbs before)

I created a database 'database1' and in users created 'user1' in my local pc. I can see the database and user that i have created through Enterprise Manager.

I want to now confirm that the user can connect to database. So, I used SQL Query Analyzer and selected 'SQL Server Authentication Mode' with SQL server = (localhost) and login name = 'user1' and password='xxxx' but i get error

'Unable to connected to server xxxx: Server : Msg 18452, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'user1'. Reason: Not associated with a trusted SQL server connection.

(Pls note : the SQL server is running (as i can see from green arrow at right bottom end of my screen and i can login to the server if i select 'Windows Authentication Mode' in LAN of my office.)

Also note : isn't the method i have done the right way to confirm that the user 'user1' that i have created has/hasnot rights for the database 'database1'.

It is urgent.

Please suggest.

 

[tamugrg13]

i have managed to resolved it. the authentication was selected to 'Windows Only'. Thanx anyway guys

 

[Stephen]

Yes, it needs to be in "Mixed Mode" to work properly.