Solved

Unable to make Azure login

Posted on 2010-09-17
4
1,257 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

When speed and performance are vital to revenue, companies must have complete confidence in their cloud environment.
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
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, f…
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…

622 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