MSSQL: Cannot open user default database. Login failed



Share this article :

Symptom

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

MSSQL - Cannot open user default database

Solution

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

Tags:

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