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 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 can backup/export my database

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

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

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

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.