无法从Visual Studio连接到Azure SQL数据库 [英] Can't connect to Azure SQL database from Visual Studio

问题描述

当我尝试在Visual Studio中打开Azure SQL Server数据库时

When I try to open my Azure SQL Server database in Visual Studio

，然后使用我的Azure用户帐户(我已经将此用户添加到SQL所有者角色)[e-mail]我遇到以下错误

and then use my Azure user account (I already added this user to SQL Owner role) [e-mail] 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 [e-mail]@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数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！