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

Check & Change MSSQL Server Compatibility Level
Find Last Database Backup & Log Backup for MSSQL Server
Move SQL Server tempdb to Another Location
How to Configure Maintenance Plan Wizard in MSSQL
© 2017 ITsiti. All Rights Reserved
Powered by KEEM