Share via

Why is a cloud database not provisioning to a data sync group?

Worldsmart 20 Reputation points
2023-06-08T03:21:35.8+00:00

I want to create a Data Sync group and provision an on-premises database with a Azure cloud database. The on-prem database syncs through SQL Data Sync fine and seems connected on Azure Portal. However when you open the Data Sync Group in Azure Portal I get the following error:

Database provisioning failed with the exception "SqlException ID: 80e7052d-9a80-4b30-95d3-8e2ee4d9604e, Error Code: -2146232060 - SqlError Number:40615, Message: Cannot open server requested by the login. Client is not allowed to access the server. To enable access, use the SQL Azure 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. For more information, provide tracing ID ‘4ba76cd9-8697-4ccd-88da-94014f274d64’ to customer support."

It seems strange to me that the 'client' in the above error can't connect to the server since it's a cloud-to-cloud connection right? How could a conversation between Azure portal (or wherever the data sync group is) and the Azure SQL database be blocked by a firewall?

The cloud database is a member of other data sync groups and the same error comes up too, I'm sure this hasn't always been the case.

Azure SQL Database
0 comments
Accepted answer
  1. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    2023-06-08T03:37:40.7066667+00:00

    Please create a firewall rule on Azure to allow incoming traffic from the SQL Server computer. Use a service like this to know the public IP used by your on-premise server.

    Ensure that the firewall on the Azure database has set Allow Azure services and resources to access this server to Yes.

    Configure Windows Firewall or security hardware/software on the SQL Server computer to allow traffic on port TCP 1433.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.