无法使用在Azure门户中创建的SQL Server身份验证连接到新的SQL Server [英] Not able to connect to new SQL Server using SQL server Authentication created in Azure Portal

问题描述

使用Azure门户创建SQL服务器和数据库。要使此SQL Server服务器/数据库可供PowerApps使用，请尝试创建防火墙规则。但是无法通过SSMS连接以使用创建的Microsoft帐户进行进一步的活动。

解决方案

您好Tejashri，

需要添加到防火墙的IP地址是运行SSMS的客户端的公共IP。您可以使用
whatismyip.com 等服务来识别您的公共IP，并添加该值至于允许列表。

对于PowerApps连接，如果启用"允许Azure服务连接"配置，则无需输入任何IP地址详细信息以允许连接。 

如果您有其他问题，请告诉我们。

问候，

Mike

Using Azure Portal SQL server and database is created . To make this SQL server / database available to PowerApps , tried to create Firewall Rule. But not able to connect thru SSMS to do further activity using microsoft account created .

解决方案

Hi Tejashri,

The IP address that needs to be added to your firewall is the Public IP of your client where you are running SSMS. You can use a service such as whatismyip.com to identify your Public IP, and add that value to the allow list.

As for PowerApps connectivity, if you enable `Allow Azure services to connect` configuration, you will not have to enter any IP Address details to allow connectivity. 

Please let us know if you have additional questions.

Regards,

Mike

这篇关于无法使用在Azure门户中创建的SQL Server身份验证连接到新的SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！