How do I change the default database of a database login in SQL 2005?

SUMMARY

This document details the step-by-step instructions on how to change the default database on a SQL Server login.

  • Grant the user with right to the database you want to set as the default database
  • Connect to the database using SQL Server Management Studio with the login you wish to change
  • Click New Query Button
  • Execute the following command
    • Alter login with default_database =
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to connect to SQL Server 2005 using SQL Server Management Studio?

DETAILSTo connect to your Microsoft SQL Server 2005 database using SQL Server Management Studio...

If I send you a backup (.bak) of my SQL Database, can you restore it?

DETAILSYes.  We do restore database backup files from your SQL Server.  But you have to...

How to configure the ASP.NET 2.0 Membership/Roles Provider to use SQL 2000 or SQL 2005?

SUMMARYThis article describes how to configure the ASP.NET 2.0 Membership/Roles provider to use...

Remote Connections for SQL Server 2008

Remote Connections to the MS SQL Server are enabled for all SQL Server 2008 instances....

Can I connect to your SQL server using an alternative port?

DETAILS No, the only open port is 1435.  If you find that your ISP or firewall is blocking...