September 11, 2003 at 8:35 am
SQL server is installed with mixed mode authentication (SQL server and windows). I created the “xyz” login and assigned it to default to a database. When I try to connect using SQL query analyzer and type in localhost or the IP of the machine to connect to the Database with the ”xyz” login it fails to connect. It gives error message “18456 Level 16” cannot connect.
If I use the sa login with localhost and IP it works.
If I use the "xyz" login and give the servername it allows login.
Which means the logins that are getting created are for some reason not allowing the user to connect if we specify the server as localhost or it’s own IP. I am not sure why this is happening. Please advise.
September 12, 2003 at 7:25 am
Did you run the QA from SQL Server machine or from another workstation?
September 12, 2003 at 7:37 am
Hello all,
The issue has been resolved. There was another MSDE running on that machine and localhost was resolving to that and that is why it was unable to login using user created logins. Localhost was not pointing to the SQL server.
Since both(MSDE and SQL server) have sa logins and the password for sa was blank on both we didn't realise this was happening until we created the sa login with a password for sql server and then tried to login. It didn't allow us to login with sa then. That's when we realised it was looking somewhere else.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply