无法从Azure门户创建登录名/用户. [英] Unable to create login / user from azure portal.

问题描述

无法从Azure门户创建登录名/用户.



创建登录myuser
WITH PASSWORD ='PASSWORD123 @'
开始


错误:

无法执行查询.错误:用户必须在master数据库中.



然后我尝试:

使用母版
开始
创建登录myuser
WITH PASSWORD ='PASSWORD123 @'
开始

Eroor:
无法执行查询.错误:不支持USE语句在数据库之间进行切换.使用新连接连接到其他数据库.


这项工作将如何进行.我不想使用SSMS和其他外部工具.

Unable to create login / user from azure portal.



CREATE LOGIN myuser
WITH PASSWORD = 'PASSWORD123@'
GO


Error:

Failed to execute query. Error: User must be in the master database.



Then I have try with :

Use master
GO
CREATE LOGIN myuser
WITH PASSWORD = 'PASSWORD123@'
GO

Eroor:
Failed to execute query. Error: USE statement is not supported to switch between databases. Use a new connection to connect to a different database.


What will be the work arround. I don't want to used SSMS and other external tools. 

推荐答案

何塞，

据我了解，您无法从Azure门户连接到master，只能连接到用户数据库

as far as I understand, you cannot connect to master from the Azure portal - only to user databases

如果要避免使用SSMS或外部工具，则可以选择使用PowerShell来完成此操作(可以直接从Cloud Shell运行-无需在以下示例中使用Web.Security.Membership引用)

If you want to avoid using SSMS or external tools, then you have the option of using PowerShell to accomplish this (which you can run directly from the Cloud Shell - sans the Web.Security.Membership references used in the following example)

https://stackoverflow.com/questions/13437045 /create-an-new-administrator-level-login-in-azure-sql

hth
马辛

hth
Marcin

这篇关于无法从Azure门户创建登录名/用户.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！