Synapse Workspace Pools and On Demand Inaccessible

This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Tech Community.

In the event that you try and connect to your SQL Pool or SQL OD database in Synapse Workspace after creating it , you could experience one of the following failures which is preventing you to access the databases objects, execute scripts or view objects within the Synapse Workspace. 

 

Identification

 

Network Error when trying to view Database Objects in the workspace 

 

SYnapse Network error.png

 

AJAX Error when selecting the database and running a statement against it in the Develop Widget 

 

Ajax error.png

 

SQL On Demand database is greyed out when attempting to connect to it and run a script against the database in the Develop widget.

 

sql OD unreachable.PNG

Cause and Mitigation

Local network is restricting access to the SQL Logical Services on Port 443 and Port 1443. 

Allow access to the services on the specified ports which would grant access to the web endpoint of the database services. 

 

Additional information can also be found in the following article 

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-connect-query-portal

 

 

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.