问题描述
当我尝试在Visual Studio中打开Azure SQL Server数据库时
When I try to open my Azure SQL Server database in Visual Studio
,然后使用我的Azure用户帐户(我已经将此用户添加到SQL所有者角色)[email protected]我遇到以下错误
and then use my Azure user account (I already added this user to SQL Owner role) [email protected] I got the following error
无法打开登录请求的服务器"DomainName.com".登录失败. (Microsoft SQL Server,错误:40532)
Cannot open server "DomainName.com" requested by the login. The login failed. (Microsoft SQL Server, Error: 40532)
推荐答案
似乎我需要使用 UserName @ DomainName.com @ AzureSQLInstanceName 作为用户名,并使用我的域密码作为密码.我是从Azure门户上的数据库连接字符串"部分获得的.
It seems to be I need to use [email protected]@AzureSQLInstanceName as a user name, and my domain password as password.I got that from the database connection strings section on Azure portal.
这篇关于无法从Visual Studio连接到Azure SQL数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!