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

If I send you a backup (.bak) of my SQL Database, can you restore it?

DETAILSYes.  We do restore database backup files from your SQL Server.  But you have to...

How can I import my database

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

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. 

Remote Connections for SQL Server 2005

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