Solved

Unable to make Azure login

Posted on 2010-09-17
4
1,138 Views
Last Modified: 2014-11-12
hi,

I have a database in Azure and am not able to create a login.  This is what i did to create one and listed below is also the error I get.  Can someone help me with this,

I am using Sql Server management studio 2008 R2

CREATE LOGIN AspNetServicesUsers
      WITH PASSWORD = 'j4341g/J4341G'
GO


error:
Msg 5001, Level 16, State 1, Line 1
User must be in the master database.
0
Comment
Question by:joygomez
  • 2
4 Comments
 
LVL 8

Expert Comment

by:avirups
ID: 33706923
When are you getting the error?
0
 
LVL 8

Expert Comment

by:avirups
ID: 33706932
You generally get this error when you have logged in and are trying to do something for which the user must then be in the scope of the master database.
0
 
LVL 3

Accepted Solution

by:
Ironnica earned 500 total points
ID: 33707880
Start your command batch with:
USE MASTER
GO
It will work!
0
 

Author Closing Comment

by:joygomez
ID: 33709087
thanks, it worked.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the market for a new backup solution for Windows Server 2016? Follow these guidelines to get the most bang for your buck.
Many CHPs use the buzzword ‘Cloud Hosting’ to sell the idea of reliability. Most consumers have the opinion that cloud hosting is easily scalable and can handle just about anything. Further, most CHPs are not transparent and hide the underlying arch…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
This Micro Tutorial will explain how to export DynamoDB tables in Amazon Web Services.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question