Azure data share SQL server lists 0 datasets does not list database objects to share

MrFlinstone 651

I have setup Azure data share, create a SQL server and a SQL database. No firewall configuration and Azure services are allowed. Public access is not allowed however I have added my IP address, encryption disabled. I have connected successfully to the database using SSMS without any issues.

However when I try to create a dataset within Azure datashare, it finds the server and database, but when one clicks on the tables it says no results found. IT cannot see the list of tables or views. I do have permissions on the SQL server and database, as it works on SSMS. DB contributor role assigned and SQL server contributor role assigned.

Not sure what else could be causing the issue.

I can only suspect its some kind of networking error, however not sure where to find the logs to ascertain why its not able to connect to SQL server.

phemanth 13,980 Reputation points Microsoft Vendor

2025-01-31T04:51:46.5933333+00:00
@MrFlinstone

Thanks for reaching out to Microsoft Q&A.

I can understand It seems like you've set up everything correctly

Please check the below steps ;

Permissions: Ensure that the Azure Data Share service has the necessary permissions to access your SQL Server and database. You might need to assign the Microsoft.Authorization/roleAssignments/write permission, which is typically part of the Owner role

Resource Provider Registration: Verify that the Azure Data Share service is registered as a resource provider in your Azure subscription. You can do this by going to the Azure portal, selecting your subscription, and checking the Resource Providers section for Microsoft.DataShare

Firewall and Network Settings: Double-check your firewall and network settings. Even though you've added your IP address, there might be other network configurations that need adjustment

Data Types and Encryption: Ensure that the data types in your SQL tables are supported by Azure Data Share. Also, while encryption is disabled, make sure there are no other security settings that might be interfering

Logs and Diagnostics: Look into the logs and diagnostics for more detailed error messages. You can find these in the Azure portal under the Monitoring section of your SQL Server and Azure Data Share resource

I hope the above steps will resolve the issue, please do let us know if issue persists. Thank you
MrFlinstone 651 Reputation points

2025-01-31T09:48:02.7666667+00:00

Tried all of the above still no luck, it can see the server its just that it cannot see the list of tables etc. The Azure data share principal was granted db ownber role at the database level, i am not sure if its that.
phemanth 13,980 Reputation points Microsoft Vendor

2025-02-03T12:01:35.1366667+00:00
@MrFlinstone

Thanks for the information.

Given that the Azure Data Share principal has been granted the db_owner role, it should have sufficient permissions to see the tables. However, there are a few additional things you might want to check:

Role Permissions: While the db_owner role should generally provide full access, there might be specific permissions or configurations that are missing. Ensure that the principal has the db_datareader role as well, which explicitly grants read access to all tables and views

Schema Visibility: Sometimes, the issue might be related to schema visibility. Ensure that the schema containing the tables is accessible and that there are no schema-specific permissions blocking access

Resource Provider Registration: Double-check that the Azure Data Share service is correctly registered as a resource provider in your Azure subscription. This can sometimes cause issues with visibility

Network and Firewall Settings: Even though you've configured the firewall and network settings, ensure there are no additional network security groups or settings that might be blocking access

Logs and Diagnostics: Review the logs and diagnostics for any specific error messages that might provide more insight into why the tables are not visible. This can often point to the exact issue

I hope the above steps will resolve the issue, please do let us know if issue persists. Thank you

MrFlinstone 651

Looking at the developer tools, I get the following.

       POST https://my-sql-database.database.windows.net:1443/databases/my-datashare/query?api-version=2018-08-01-preview net::ERR_TIMED_OUT

MrFlinstone 651 Reputation points

2025-02-03T23:18:16.0066667+00:00
After checking developer tools, i get the following timeout errors.

POST https://my-sql-database.database.windows.net:1443/databases/my-datashare/query?api-version=2018-08-01-preview net::ERR_TIMED_OUT
phemanth 13,980 Reputation points Microsoft Vendor

2025-02-05T19:00:00.6733333+00:00
@MrFlinstone

It looks like you're encountering a timeout error when trying to connect to your SQL database. Here are a few additional steps to troubleshoot this issue:

Network Configuration: Ensure that the network configuration allows traffic on port 1443. This port is typically used for SQL Server connections, and any restrictions or blocks on this port could cause timeout errors.

Firewall Rules: Double-check your firewall rules to ensure that they are not blocking the connection. Even though you've added your IP address, there might be other firewall settings that need adjustment.

SQL Server Configuration: Verify that your SQL Server is configured to accept connections on port 1443. You can check this in the SQL Server configuration settings.

Resource Provider Registration: Ensure that the Azure Data Share service is correctly registered as a resource provider in your Azure subscription. This can sometimes cause issues with connectivity.

Logs and Diagnostics: Review the logs and diagnostics for any specific error messages that might provide more insight into why the connection is timing out. This can often point to the exact issue.

Retry Logic: Implement retry logic in your connection attempts. Sometimes, transient network issues can cause timeouts, and retrying the connection can help overcome these temporary problems.

I hope the above steps will resolve the issue, please do let us know if issue persists. Thank you

Share via

Azure data share SQL server lists 0 datasets does not list database objects to share

Your answer