Changing the default database of a MS SQL database login

How to change the default database on a SQL Server login:
  1. Grant the user with right to the database you want to set as the default database (see this Knowledge Base article)
  2. Connect to the database using SQL Server Management Studio with your primary sql login 
  3. Click New Query Button
  4. Execute the following command:
Alter login <loginname> with default_database = <name of default database>
 
Replace <loginname> and <name of default database> with the sql login name (primary or secondary) and database name.
Did you know that our Cloud Backup service can also back up your database? You have full control over backup retention and schedule. Automate your backups now with Cloud Backup.