Monday, February 18, 2013 8:58 PM
How do I manually create a second Login for SQL Azure?
How do I execute the 'Create LOGIN' SQl statement?
"Msg 5001, Level 16, State 1, Line 1
User must be in the master database."
But there is no master database that I can see.
How is this done?
- Moved by Kalman TothMicrosoft Community Contributor Monday, February 18, 2013 9:17 PM Azure SQL
Monday, February 18, 2013 11:01 PMModeratorEach Windows Azure SQL Database server has a master database. The instructions for creating additional logins is documented here.
Monday, February 18, 2013 11:30 PM
Where is the SQL Azure database master database and how do I get to it?
I do not see the database in VS2010 or in the SQl Azure portal.
Tuesday, February 19, 2013 2:55 AMModeratorIn the Windows Azure SQL Database section of the Portal, click on Servers and then Manage. You will be presented with a page requesting credentials and the name of a database to sign in to. You can specify master there. The master database is also exposed under System Databases in SSMS.
Tuesday, February 19, 2013 10:45 PM
Is there any documentation that shows how to acces the Azure SQL Database master database?
Thursday, February 21, 2013 7:26 AMModerator
Before your query will solve this problem.
TechNet Community Support