==========================================================
如何在 Visual Studio 中链接上Azure SQL 数据库
==========================================================
在VS中,抬头菜单按 View, 选择打开Server Explorer
鼠标点在Data Connetions 处按鼠标右键,选择Add Connection
Data Source 选择 Microsoft SQL Server (SqlClient)
Server Name: ****.database.windows.net
或者 tcp:****.database.windows.net,1433
下面选择 SQL Server Authentication
User name: guanliyuan@*****
Password: ***********
按 Test Connection 成功后按OK
address XXXXX is not allowed to access the server
如何在 Visual Studio 中链接上Azure SQL 数据库
==========================================================
在VS中,抬头菜单按 View, 选择打开Server Explorer
鼠标点在Data Connetions 处按鼠标右键,选择Add Connection
Data Source 选择 Microsoft SQL Server (SqlClient)
Server Name: ****.database.windows.net
或者 tcp:****.database.windows.net,1433
下面选择 SQL Server Authentication
User name: guanliyuan@*****
Password: ***********
按 Test Connection 成功后按OK
==========================================================
address XXXXX is not allowed to access the server
可以在Azure里的找到SQL Server, 在设置防火墙, 将 XXXXX 地址输入到里面.
如何查看Azure 数据库的 Server Name, User Name ?
Azure 中,找到SQL Database,看Overview, 再看 Connection strings 里面