Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
How do I create a second login for SQL Azure?

Respondido How do I create a second login for SQL Azure?

  • Monday, February 18, 2013 8:58 PM
     
     
    Sign In to Vote
    0

    How do I manually create a second Login for SQL Azure?

    How do I execute the 'Create LOGIN' SQl statement?

    It says:

    "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?

     

All Replies

  • Monday, February 18, 2013 11:01 PM
    Moderator
     
     
    Sign In to Vote
    0
    Each 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
     
     
    Sign In to Vote
    0

    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 AM
    Moderator
     
     
    Sign In to Vote
    0
    In 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
     
     
    Sign In to Vote
    0

    Is there any documentation that shows how to acces the Azure SQL Database master database?

     
  • Thursday, February 21, 2013 7:26 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi Don,

    Add:

    use master
    go

    Before your query will solve this problem.

    TechNet Subscriber Support

    If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

    Iric Wen
    TechNet Community Support