question

GopalakrishnanKalan-8405 avatar image
0 Votes"
GopalakrishnanKalan-8405 asked PRADEEPCHEEKATLA-MSFT commented

Why my data set is not created during data share

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,

azure-data-share
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @GopalakrishnanKalan-8405,

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.

110885-ads-azsqldb.gif

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.


ads-azsqldb.gif (1023.6 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @GopalakrishnanKalan-8405,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hello @GopalakrishnanKalan-8405,

Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.

0 Votes 0 ·