SQL Server Performance Forum – Threads Archive

Default Database for Login IDs Were Changed

Hi All! Here’s the problem: Yesterday, our technical/network admin reported that one of the hard disks on our sql server failed. After office hours, the hard disk was changed but in doing so the databases were detached and re-attached successfully. I found out this morning that SQL Server Login IDs were defaulted to a database where that Login ID does not even have access at all. Thus, whenever a user tried to connect through SQL Query Analyzer, below error message appears: "Unable to connect to server [servername]: Server: Msg 4064, Level 16, State 1 [Miscrosoft][ODBC SQL Server Driver][SQL Server]Cannot open user default database. Login failed." As a work-around, I manually changed the user’s default database to the one that they can or have access. Any ideas what could possibly went wrong with this? Thanks, [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]Jon M

You’d have to make sure that the database id of the detached database was the same when it was reattached… not that likely if you detach all databases and then attach them all at a later time the login table holds the id of the default database, this is not updated during a detach/attach operation So yes manually resetting the default db is the only way (that I can think of) Cheers
Twan

Take help of this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;Q307864 _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>