SQLTeam.com | Weblogs | Forums

Database connection was successful, but database login failed


We had to rebuild a machine that needed an ODBC setup hat we didn't know the sa password (wasn't documented when originally set-up). I downloaded SSMS and changed the password. Now we receive the following error:
"Database connection was successful, but database login failed"

Thanks for the help in advance,

Wes Cumbee


there are multiple levels of authentication
serve level
database level

sounds like your user can login to server but not to specific database


hmm..no permissions were changed. We only updated the sa password.


you did rebuild it right? sa guid/uid might have changed so that the settings might have changed on database level