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.
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.