Thanks to Fritz Laurel for adding this in the comments section, after you gain access you may need to run this script to store the new default database for the Login you used.
ALTER LOGIN loginid
WITH DEFAULT_DATABASE = master
GO
June 18, 2007
UPDATE: Cannot open user default database. Login failed. Login failed for user ‘UserName’. (Microsoft SQL Server, Error: 4064)
2 Comments »
RSS feed for comments on this post. TrackBack URI
Database Log In Failed
An invalid username/password caused log in to database fail.
Verify that the username/password you provided is correct.
Comment by Deepthi Jaju — September 12, 2007 @ 5:20 am
In one of our Database we used to login through one username And now the user name is changed.NOw we are not able to open the apllication.Can any one suggest wat to do
the error is as follows.
Database Log In Failed
An invalid username/password caused log in to database fail.
Verify that the username/password you provided is correct.
Comment by Deepthi Jaju — September 12, 2007 @ 5:22 am