连接到Azure SQL [英] Connect to Azure SQL
问题描述
大家好,
我在使用SQL Managment Studio连接到AzurSQL时遇到严重问题
i have serious Problems connecting to AzurSQL with SQL Managment Studio
我在Azure上的帐户具有"firstname.lastname@mymail.com"
My Account on Azure is with 'firstname.lastname@mymail.com'
Azure告诉我服务器名称为"XxxYyy".
Azure told my that the Servername is 'XxxYyy'.
我从天蓝色得到的全部是'用户'XxxYxx'错误18456的登录失败'
All what i get from azure is 'Loggin faild for user 'XxxYxx' Error 18456'
即使我尝试从Visual Studio 2017中打开数据库也会导致相同的结果.
Even if i try to open the Database from Visual Studio 2017 leads to the same result.
有什么想法吗?
预先感谢
Peter
推荐答案
彼得,
您是否已将Azure SQL数据库逻辑服务器配置为使用Azure AD身份验证?
did you configure your Azure SQL Database logical server to use Azure AD authentication?
如果没有,那么您应该使用在创建逻辑服务器时指定的管理员帐户登录
If not, you should be logging on using the admin account that you specified when creating the logical server
详细信息,位于 https://docs.microsoft.com/zh-CN/azure/sql-database/sql-database-connect-query-ssms
Details at https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-ssms
hth
Marcin
hth
Marcin
这篇关于连接到Azure SQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!