Tag - ALTER LOGIN WITH DEFAULT_DATABASE

Learn SQL Server SQL Server

Fix Cannot open user default database. Login failed. Login failed for user SQL Server Error

Introduction In this article we will take a look at the steps which you need to follow when you receive “Cannot open user default database. Login failed. Login failed for user ‘UserName’. (Microsoft SQL Server, Error:...

Ashish Mehta

Add comment

1,163 views

-->

How to Move TempDB to New Drive in SQL Server

How to Verify and Register SPN for SQL Server Authentication with Kerberos Connections

Different SQL Server Recovery Models Step by Step Tutorial with Examples

Identify Deadlocks in SQL Server Using Trace Flag 1222 and 1204

How to Enable & Disable XP_CMDSHELL using SP_CONFIGURE in SQL Server

Convert Seconds to Minutes, Hours and Days in SQL Server

Display Line Numbers in SQL Server Management Studio (SSMS)

Download SQL Server 2016 Developer Edition for Free

Drop Database in SQL Server by Killing Existing Connections

How to Fix Cannot execute script. Insufficient memory to continue the execution of the program (mscorlib) error in SQL Server

How to Change Select Top 1000 Rows and Edit Top 200 Rows Default Value in SQL Server Management Studio

SQL Server: How to Start SQL Server with Minimal Configuration

SQL Server SIMPLE Recovery Model Step by Step Tutorial with Examples

How to Repair Suspect Database in SQL Server | DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS | Repair Suspect Database

Different Ways to Find Default Trace Location in SQL Server

Download SQL Server 2014 Developer Edition Free

Troubleshooting SQL Server blocked access to procedure sp_send_dbmail

SQL Server: How to Find which user deleted the database in SQL Server

How to Enable and Refresh IntelliSense in SQL Server Management Studio (SSMS)

SQL Server FULL Recovery Model Step by Step Tutorial with Examples

Configure Network Drive Visible for SQL Server During Backup and Restore Using SSMS

SQL Server: How to Start SQL Server in Single User Mode?

How to Change SQL Server Database Auto Growth Settings