“Cannot open user default database. Login failed.” after installing SQL Server Management Studio Express

by

This may not be answering your question specifically, but it may help others with similar issue caused by different problem

In my case the problem was my user is defaulted to a database which is not accessible for any reason (can be renamed, removed, corrupted or …)
To solve the issue just follow the following instruction

  1. Try to login again on the login page there is other tabs select
    “Connection Properties”.

  2. under the tab locate “Connect to database” and select an existing database you have access to like tempdb or master

  3. Once you are connected to the SQL Server Instance execute the below TSQL to assign the login a new default database.

    Use master
GO

ALTER LOGIN [yourloginname] WITH DEFAULT_DATABASE = TempDB
GO

Alternatively once you connected change your default database name to master via UI

Article taken from :
http://www.mytechmantra.com/LearnSQLServer/Fix-cannot-open-user-default-database-Login-failed-Login-failed-for-user-SQL-Server-Error/

More Related Contents:

  1. What is the point of “Initial Catalog” in a SQL Server connection string?
  2. Updating image in VB and SQL Server not working [closed]
  3. Cannot Connect to Server – A network-related or instance-specific error
  4. LocalDB deployment on client PC
  5. Query to list number of records in each table in a database
  6. Storing a file in a database as opposed to the file system?
  7. Multiple Indexes vs Multi-Column Indexes
  8. SQL Server named instance with Visual Studio 2017 Installer project
  9. Preferred Method of Storing Passwords In Database
  10. Using a sort order column in a database table
  11. Create a view with ORDER BY clause
  12. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  13. How to do version control for SQL Server database?
  14. How to determine total number of open/active connections in ms sql server 2005
  15. How to check if a database exists in SQL Server?
  16. How can I do a BEFORE UPDATED trigger with sql server?
  17. Getting execute permission to xp_cmdshell
  18. How to migrate a PostgreSQL database into a SQLServer one?
  19. How to create a yes/no boolean field in SQL server?
  20. What does “exec sp_reset_connection” mean in Sql Server Profiler? [duplicate]
  21. Best way to store time (hh:mm) in a database
  22. Can SQL Server Express LocalDB be connected to remotely?
  23. How can I run just the statement my cursor is on in SQL Server Management Studio?
  24. Executing set of SQL queries using batch file?
  25. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  26. Date range overlapping check constraint
  27. Difference between database and schema
  28. Calculate Time Difference Between Two Rows
  29. How do you deal with blank spaces in column names in SQL Server?
  30. Tool for Scripting Table Data

Leave a Comment