Why my data set is not created during data share

Question

Creating a data set using the data share from SQL server source. My data set creation is failed during the process. It says , its due to the firewall settings at the SQL server. But i am given the ip address in the client ip. I am able to successfully connect to db using sqlcmd.

Any help is highly appreciated,

Answer 1

Hello @Gopalakrishnan Kalan ,

Thanks for the question and using MS Q&A platform.

Make sure you have followed the Prerequisites for sharing from Azure SQL Database.

To share data using Azure Active Directory authentication, here is a list of prerequisites:

• An Azure SQL Database or Azure Synapse Analytics (formerly Azure SQL DW) with tables and views that you want to share.
• Permission to write to the databases on SQL server, which is present in Microsoft.Sql/servers/databases/write. This permission exists in the Contributor role.
• SQL Server Azure Active Directory Admin
• SQL Server Firewall access.

This can be done through the following steps:

1. In Azure portal, navigate to SQL server. Select Firewalls and virtual networks from left navigation.
2. Click Yes for Allow Azure services and resources to access this server.
3. Click +Add client IP. Client IP address is subject to change. This process might need to be repeated the next time you are sharing SQL data from Azure portal. You can also add an IP range.
4. Click Save.

For more details, you can follow the step by step demo to configure prerequisites.

You can follow the below steps to Start sharing your data for Azure SQL Database.

For more details, refer to Share and receive data from Azure SQL Database.

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.