?
Solved

Unable to make Azure login

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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

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

Media Temple is thrilled to announce the launch of our new Partner Program, specifically designed to empower digital agencies and adtech platforms by offering white-glove support and exclusive hosting enhancements to optimize their sites and their c…
Cloud is selling like hotcakes in the town. Technology lovers and even businesses have joined the wagon to taste a piece of this delicious technology treat. But how many of us really know what cloud is?
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
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…
Suggested Courses

588 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