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 can I import my database

You can import your database by going to http://sqladmin.oissite.net/. You need to login using...

Remote Connections for SQL Server 2005

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

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

Can I have more logins for my MS SQL database?

DETAILS Yes.  In addition to the default login assigned for each SQL database addon, you...

Remote Connections for SQL Server 2008

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