Ask a Question

New user cannot login to SQL Azure

in Education by
I am creating a new read/write user on SQL Azure as follows: -- Connected to master create login [fred] with password = 'xxx'; -- Connected to my DB create user [fred] from login fred; EXEC sp_addrolemember 'db_datareader', 'fred'; EXEC sp_addrolemember 'db_datawriter', 'fred'; When I log in using SSMS I get an error saying Cannot open database "master" requested by the login. The login failed. What am I doing wrong or missing? Select the correct answer from above options

1 Answer

0 votes
by
 
Best answer
SSMS tries to connect to the master database by default, but your new account does not have access to the master database In the SSMS portal, you need to specify the database name.click on the options, which opens up the Connection Properties tab. Now specify the database name over there which you are trying to connect to.

Related questions

0 votes
Q: SQL Azure - copy table between databases
    I am trying to run the following SQL: INSERT INTO Suppliers ( [SupplierID], [CompanyName]) Select [SupplierID], [ ... is very slow. Select the correct answer from above options...
asked Jan 31, 2022 in Education by JackTerrance
0 votes
Q: When should I use Sql Azure and when should I use table Storage?
    When should I use SQL Azure and when should I use table Storage? I was thinking, use table storage for transaction ... do you think? Select the correct answer from above options...
asked Jan 31, 2022 in Education by JackTerrance
0 votes
Q: Stopping SQL Azure DB when not in use
    Is there any way to stop a SQL Azure DB so that it doesn't charge anything towards our account? I don't ... cloud services and VM's. Select the correct answer from above options...
asked Jan 31, 2022 in Education by JackTerrance
0 votes
Q: Tables without a clustered index are not supported in this version of SQL Server
    I am working on vs 2010 and EF 4.1 with SQL server database. Below mentioned code works fine with local SQL ... , Func`1 continuation) Select the correct answer from above options...
asked Feb 3, 2022 in Education by JackTerrance
0 votes
Q: SQL structure such as table names, column names, and so on cannot be escaped, and thus user-supplied structure names are dangerous. This is a common issue in a report-writing software.
    SQL structure such as table names, column names, and so on cannot be escaped, and thus user-supplied structure names are ... issue in a report-writing software. 1. True 2. False...
asked Mar 20, 2021 in Technology by JackTerrance
0 votes
Q: How to find solution when 200 user access site and call a store at the same time made SQL Server Azure die
    I have a store to get a list of something in system. To get information by business requirement, this ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 9, 2022 in Education by JackTerrance
0 votes
Q: How to load requireJs file only once when a user login and prevent it from loading every time page re-loads
    I have minified all my js files using require, but require created a minified js file( main.min.js ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jun 18, 2022 in Education by JackTerrance
0 votes
Q: How to load requireJs file only once when a user login and prevent it from loading every time page re-loads
    I have minified all my js files using require, but require created a minified js file( main.min.js ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jun 16, 2022 in Education by JackTerrance
0 votes
Q: SSHing into EC2 server via gives error Please login as the ec2-user user rather than root user
    The question as the title. Why is this, I have used the ssh command: ssh -i mykey.pem root@xxx-xxx-xx-xx-xxx ... What am I doing wrong? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
Q: Cannot grant UNLIMITED TABLESPACE to created user
    I am using oracle 10g. I have a database user TDM_DD which executes a procedure in which it creates ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 3, 2022 in Education by JackTerrance
0 votes
Q: In a database where the encryption is applied the data is cannot be handled by the unauthorised user without
    In a database where the encryption is applied the data is cannot be handled by the unauthorised user ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: Cannot Generate Database from Entity Framework 4.1 Codefirst With SQL Server 2005
    I try to create database from entity framework code first follow with this tutorial http://www.asp.net/mvc ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 2, 2022 in Education by JackTerrance
0 votes
Q: Cannot install Microsoft Power Bi Postgre SQL connector
    I am trying to use Microsoft Power Bi to connect to a PostgreSQL database. When I go to Get Data it just ... driving me crazy! Thanks Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
Q: Cannot install Microsoft Power Bi Postgre SQL connector
    I am trying to use Microsoft Power Bi to connect to a PostgreSQL database. When I go to Get Data it just ... driving me crazy! Thanks Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
Q: Question 15:15.….is a type of response test used incomputing as an attempt to ensure that the responseis generated by a person.a) User code b) Captcha coded) Public codec) New
    Question 15: 15. .is a type of response test used in computing as an attempt to ensure that the response is ... code c) New code Select the correct answer from above options...
asked Dec 15, 2021 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...