Login failed for user 'username' | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Login failed for user ‘username’

Hi!<br />Today I attached one database which we have detached in earlier ocassion as the application was not in use.Now after attaching db, when i checked the application I got the following error.<br />Microsoft OLE DB Provider for SQL Server error ‘80040e4d’ <br /><br />Login failed for user ‘username’. <br /><br />/LM/W3SVC/470660083/Root/global.asa, line 10 <br /><br />When I connect with the db through QA I am able to connect to the database,but in application i got this error.Pls tell mewhat to do.The sysxlogin and sysusers table have same sid.<br />here is the connection string of global.asa<br /><br />provider=’sqloledb’;data source=’ip add of dbserver’,userid=’user'<img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />assword=’pwd'<br />
Hi http://support.microsoft.com/default.aspx?scid=kb;en-us;Q222828 Please check this. This should solve your issue .
All users?
Luis Martin
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
nope only this user
Did you try to run: EXEC sp_change_users_login ‘REPORT’ on the database? If not, run it and see if any records are returned.
[email protected] When life gives you a lemon, fire the DBA.