%3CLINGO-SUB%20id%3D%22lingo-sub-1403485%22%20slang%3D%22en-US%22%3ESynapse%20Workspace%20Pools%20and%20On%20Demand%20Inaccessible%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1403485%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20event%20that%20you%20try%20and%20connect%20to%20your%20SQL%20Pool%20or%20SQL%20OD%20database%20in%20Synapse%20Workspace%20after%20creating%20it%20%2C%20you%20could%20experience%20one%20of%20the%20following%20failures%20which%20is%20preventing%20you%20to%20access%20the%20databases%20objects%2C%20execute%20scripts%20or%20view%20objects%20within%20the%20Synapse%20Workspace.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CU%3E%3CSTRONG%3EIdentification%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENetwork%20Error%20when%20trying%20to%20view%20Database%20Objects%20in%20the%20workspace%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SYnapse%20Network%20error.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193142i6E85049D71E52853%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22SYnapse%20Network%20error.png%22%20alt%3D%22SYnapse%20Network%20error.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAJAX%20Error%20when%20selecting%20the%20database%20and%20running%20a%20statement%20against%20it%20in%20the%20Develop%20Widget%E2%80%83%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ajax%20error.png%22%20style%3D%22width%3A%20529px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193143iA61337A3A6409435%2Fimage-dimensions%2F529x201%3Fv%3D1.0%22%20width%3D%22529%22%20height%3D%22201%22%20title%3D%22Ajax%20error.png%22%20alt%3D%22Ajax%20error.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESQL%20On%20Demand%20database%20is%20greyed%20out%20when%20attempting%20to%20connect%20to%20it%20and%20run%20a%20script%20against%20the%20database%20in%20the%20Develop%20widget.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22sql%20OD%20unreachable.PNG%22%20style%3D%22width%3A%20508px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193144i6755D6C0CEA1E191%2Fimage-dimensions%2F508x61%3Fv%3D1.0%22%20width%3D%22508%22%20height%3D%2261%22%20title%3D%22sql%20OD%20unreachable.PNG%22%20alt%3D%22sql%20OD%20unreachable.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%0A%3CP%3E%3CU%3E%3CSTRONG%3ECause%20and%20Mitigation%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%0A%3CP%3ELocal%20network%20is%20restricting%20access%20to%20the%20SQL%20Logical%20Services%20on%20Port%20443%20and%20Port%201443.%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAllow%20access%20to%20the%20services%20on%20the%20specified%20ports%20which%20would%20grant%20access%20to%20the%20web%20endpoint%20of%20the%20database%20services.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAdditional%20information%20can%20also%20be%20found%20in%20the%20following%20article%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-connect-query-portal%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-database%2Fsql-database-connect-query-portal%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1403485%22%20slang%3D%22en-US%22%3E%3CP%3ESynapse%20Workspace%20makes%20use%20of%20a%20web%20endpoint%20to%20access%20the%20database%20in%20the%20event%20that%20connectivity%20is%20restricted%20on%20this%20port%2C%20database%20connectivity%20will%20be%20affected.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1403485%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESynapse%20Security%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESynapse%20SQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESynapse%20Studio%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

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