FG
💻 Software

SQL Server Management Studio ignores default DB

Fresh7 days ago
Mar 15, 20261312 views
Confidence Score0%
0%

Problem

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 Connect…

Error Output

<default>

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: SQL Server Management Studio ignores default DB

Low Risk

Change the default database of your database user. I suspect that group permissions are snarling you up. You can use the stored procedure. Or you could use this bit of SQL:

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment