why my Selfhosted, dedicated sql pool and builtin sql pool

Question

why cant i access my SHIR, Sql Pools at the same time i was using all of them till yesterday and now all of the sudden everything is unavailable

Answer 1

Hi @Raghuveeravenkata Pasala

Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query!

As I understand that you are facing difficulties accessing your Self-hosted Integration Runtime (SHIR) and SQL pools. There could be several reasons why you are unable to access your Self-hosted Integration Runtime (SHIR) and SQL pools. Common issues include network connectivity problems, service outages, or configuration changes that may have occurred unexpectedly. It's advisable to check the Azure service status and your configuration settings for any discrepancies.

Here are some possible reasons for inaccessibility:

Network Connectivity Issues - Ensure your internet connection is stable. Check for any firewall settings that might be blocking access to Azure services. Verify that your IP address is whitelisted in the firewall settings of your SQL pools.I understand you're facing difficulties accessing your Self-hosted Integration Runtime (SHIR) and SQL pools.

Service Outages - Visit the Azure Service Status page to see if there are any ongoing outages or maintenance activities affecting your services.

Configuration Changes - Review any recent changes made to your SQL pools or SHIR settings that could impact accessibility. Confirm that your SQL pools are not paused or undergoing scaling operations.

Firewall Settings - If your storage is protected by a firewall, ensure that the firewall rules allow access to the SQL pool.

Subscription Issues - If you recently transferred your subscription to a different Microsoft Entra tenant, you might experience issues with the serverless SQL pool. In this case, creating a support ticket may be necessary.

For additional information, please refer the below documentations which might help you in getting some useful insights.

Troubleshooting connectivity issues in dedicated SQL pool (formerly SQL DW)

Troubleshoot serverless SQL pool in Azure Synapse Analytics

I hope this information helps. Please do let us know if you have any further queries.

Thank you.