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

SQL Server Native Client Installation Steps
Enable Login Auditing in MSSQL Server
Move SQL Server tempdb to Another Location
How to Enable MSSQL Backup Restore to Mapped Network Drive
© 2017 ITsiti. All Rights Reserved
Powered by KEEM