7

When I use SQL Server Management Studio to log in to databases, it ignores my default DB and always puts me in master. I checked that my Windows user has a login with the correct DB set, and I tried changing the default DB of groups that I'm in without any effect. At login, I tried going to Connection Properties and setting "Connect to Database" to <default>, but it always gets reset to master. If I run Management Studio as a different Windows user, it applies default DB correctly.

Any ideas?

Improve this question
1
  • There may be something wrong with SQL Server Management Studio and you could reinstall it.
    – Ahmed Bilfaqih
    Jan 4, 2012 at 22:02

2 Answers 2

Reset to default
4
+50

Change the default database of your database user. I suspect that group permissions are snarling you up. You can use the sp_defaultdb stored procedure.

Exec sp_defaultdb @loginame='login', @defdb='database'

Or you could use this bit of SQL:

ALTER LOGIN  [DOMAIN\login] 
WITH DEFAULT_DATABASE = master
Improve this answer
1
  • Thanks, but that didn't work. Default database was already showing up correctly for the Login.
    – RossFabricant
    Jan 4, 2012 at 20:15
1

It was just an issue with one account, so I now run Management Studio through a different account, using a BAT file with the following: 

runas /profile /savecred /user:DOMAIN-NT\service-account "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .