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 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