I have got one situation., while configuring service accounts and other accounts, I have given my project database as my default database., later my PM wants to downlod mdf., so I have detached them from SQL... I have closed that session and went for weekend roaming.,
monday when I try logging in I couldn't.. since my login's default db is not available it was not allowing me to login...
here is the trick,
in Login popup, go to optinons and type master or msdb in Database field and try., connect., Managmenet studio would allow you to get in., then from master db, write a query to change your default db
Alter Login [login name] Default database [master]
now all is well ;-)
monday when I try logging in I couldn't.. since my login's default db is not available it was not allowing me to login...
here is the trick,
in Login popup, go to optinons and type master or msdb in Database field and try., connect., Managmenet studio would allow you to get in., then from master db, write a query to change your default db
Alter Login [login name] Default database [master]
now all is well ;-)
No comments:
Post a Comment