Changing the default database for a SQL Azure login

Question

I would like to change the default database for login to support software that can access SQL Azure but does not allow easy alteration of a connection string. It appears that SQL Azure defaults to the master database.

I've already considered:

• Stored procedures. I can't find a stored procedure that does this (sp_defaultdb is not implemented in SQL Azure as far as I can tell)
• Alter Login. ALTER LOGIN does not permit the DEFAULT_DATABASE option.
• SSMS. SSMS doesn't seem to allow much user control through the interface for SQL Azure.

Ideas?

Answer 1

You can do the following:

1. Make changes in the connection string

Server=tcp:hello7.database.windows.net,1433;Initial Catalog=helloworld;Persist Security Info=False;User ID={your_username};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

Change the database name in the string.

2. In SSMS, here is what you can do while login in.