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

Can I have more than 1 MS SQL database with my hosting account?

DETAILS Yes.  You can order up to 5 MS SQL 2000 database addons per account. 

How can I import my database

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

How can backup/export my database

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

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

Do you support MS SQL 2005 Express database on your servers?

DetailsNo. SQL Express is designed for desktop database development purposes and is not suitable...