Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Unable to make Azure login

Posted on 2010-09-17
4
Medium Priority
?
1,340 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 2000 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

The following article is comprised of the pearls we have garnered deploying virtualization solutions since Virtual Server 2005 and subsequent 2008 RTM+ Hyper-V in standalone and clustered environments.
On Feb. 28, Amazon’s Simple Storage Service (S3) went down after an employee issued the wrong command during a debugging exercise. Among those affected were big names like Netflix, Spotify and Expedia.
This Micro Tutorial will explain how to export DynamoDB tables in Amazon Web Services.
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

877 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