Blog Post

Azure Synapse Analytics Blog
1 MIN READ

Synapse Workspace Pools and On Demand Inaccessible

CharlRoux's avatar
CharlRoux
Icon for Microsoft rankMicrosoft
May 19, 2020

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 

 

 

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

 

 

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

 

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

 

 

Updated May 19, 2020
Version 1.0
No CommentsBe the first to comment