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

Remote Connections for SQL Server 2005

HELM4 Accounts: Connection information can be found within the Database Manager screen. to get to...

Transferring SQL 2005 databases

SUMMARYThis document provides a step-by-step guide on how to transfer your current SQL Server...

How do I assign additional SQL logins to my SQL 2005 database?

SUMMARYThis document details the step-by-step instructions on how to assign a SQL login...

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