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

How can I import my database

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

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

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. 

Remote Connections for SQL Server 2008

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