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 Database Status
Restrict Access to SQL Server Database
Definition: mdf, ndf & ldf (SQL Server)
Disconnect / Kick All Users from MSSQL Server Database
© 2018 ITsiti. All Rights Reserved
Powered by KEEM