MSSQL: Cannot open user default database. Login failed

Share this article :


You want to login to the database using SQL Management Studio but ended up with below error,

MSSQL - Cannot open user default database


1. Click on Options.

SQL Studio - Options

2. Change the Connect to database from <default> to master. Now, click on Connect and you should be able to login now.

SQL Studio - Connection Properties


Related posts

Check SQL Server Native Client Version
Disconnect / Kick All Users from MSSQL Server Database
Restore of database 'SID' failed. Exclusive access could not be obtained because the database is in ...
Login failed for user. (Microsoft SQL Server, Error: 18456)
© 2017 ITsiti. All Rights Reserved
Powered by KEEM