Issue:-
While connecting with Azure Failover groups listeners, I get following error in SQL Server 2014 SSMS.
Cannot connect to XXXXXlistener.database.windows.net.
------------------------------
ADDITIONAL INFORMATION:
Cannot open server 'sqlsouthasia' requested by the login. Client with IP address '61.62.123.64' is not allowed to access the server. To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect. (Microsoft SQL Server, Error: 40615)
Resolution:-
As per suggestion, we have to execute sp_set_firewall_rule sp from master databases of the server or from Azure portal will have to add 61.62.123.64 IP address.
While connecting with Azure Failover groups listeners, I get following error in SQL Server 2014 SSMS.
Cannot connect to XXXXXlistener.database.windows.net.
------------------------------
ADDITIONAL INFORMATION:
Cannot open server 'sqlsouthasia' requested by the login. Client with IP address '61.62.123.64' is not allowed to access the server. To enable access, use the Windows Azure Management Portal or run sp_set_firewall_rule on the master database to create a firewall rule for this IP address or address range. It may take up to five minutes for this change to take effect. (Microsoft SQL Server, Error: 40615)
Resolution:-
As per suggestion, we have to execute sp_set_firewall_rule sp from master databases of the server or from Azure portal will have to add 61.62.123.64 IP address.
The query is
exec sp_set_firewall_rule N'office', '61.62.123.64', '61.62.123.64';
or using Azure portal
The issue will resolve
Thanks for reading..
