%3CLINGO-SUB%20id%3D%22lingo-sub-1993119%22%20slang%3D%22en-US%22%3ETroubleshooting%20Synapse%20Studio%20tips%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1993119%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFollowing%20a%20concise%20summary%20of%20some%20tips%20for%20troubleshooting%20Synapse%20Studio%3A%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsynapse-analytics%2Ftroubleshoot%2Ftroubleshoot-synapse-studio-powershell%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ETroubleshoot%20Synapse%20Studio%20connectivity%20-%20Azure%20Synapse%20Analytics%20%7C%20Microsoft%20Docs%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsynapse-analytics%2Ftroubleshoot%2Ftroubleshoot-synapse-studio%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ETroubleshoot%20Synapse%20Studio%20-%20Azure%20Synapse%20Analytics%20%7C%20Microsoft%20Docs%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CU%3E%3CSTRONG%3EExamples%3C%2FSTRONG%3E%3C%2FU%3E%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1)%20I%20am%20trying%20to%20load%20SQLDW%20on%20Synapse%20Studio%20and%20it%20shows%20not%20accessible.%20Keep%20in%20mind%20make%20questions%20to%20investigate%20the%20issue%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EDo%20you%20in%20fact%20have%20permission%20to%20open%20SQLDW%3F%3C%2FLI%3E%0A%3CLI%3EIs%20your%20SQL%20DW%20pause%3F%3C%2FLI%3E%0A%3CLI%3ECan%20you%20connect%20from%20SSMS%20or%20Azure%20Data%20Studio%3F%3C%2FLI%3E%0A%3CLI%3EDoes%20the%20issue%20affect%20only%20your%20user%20or%20Any%20User%3F%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Synapsestudioerror.png%22%20style%3D%22width%3A%20393px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F241018iC09E3D1E52637B6D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Synapsestudioerror.png%22%20alt%3D%22Synapsestudioerror.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EScript%20to%20check%20permissions%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3ESELECT%20%20%20%20%20DPUsers.name%2C%20'has%20the%20'%0A%20%20%20%20%20%20%20%20%20%20%20%2C%20permission_name%0A%20%20%20%20%20%2C%20'permission%20on%20the%20item%20described%20as%20class%20%3D%20'%0A%20%20%20%20%20%2C%20class%2C%20'id%20%3D%20'%0A%20%20%20%20%20%2C%20major_id%0AFROM%20sys.database_permissions%20AS%20DP%0AJOIN%20sys.database_principals%20AS%20DPUsers%0A%20%20%20%20ON%20DP.grantee_principal_id%20%3D%20DPUsers.principal_id%0A%20--where%20DPUsers.name%20like%20'nameoftheuser'%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20are%20trying%20to%20use%20SQL%20Serverless%20and%20the%20database%20is%20unreachable.%3C%2FP%3E%0A%3CP%3EAlmost%20the%20same%20questions%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ECan%20you%20connect%20from%20SSMS%20or%20Azure%20Data%20Studio%3F%3C%2FLI%3E%0A%3CLI%3EDoes%20the%20issue%20affect%20only%20your%20user%20or%20Any%20User%3F%3C%2FLI%3E%0A%3CLI%3EDoes%20this%20issue%20affect%20only%20your%20user%20or%20any%20user%3F%3C%2FLI%3E%0A%3CLI%3EIf%20you%20switch%20browser%20can%20you%20connect%3F%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22SQLodUnre.png%22%20style%3D%22width%3A%20401px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F241019i9ED5B0920B0C6310%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22SQLodUnre.png%22%20alt%3D%22SQLodUnre.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20one%20of%20the%20cases%2C%20we%20had%20a%20situation%20while%20the%20customer%20was%20using%20firefox%20when%20he%20hit%20this%20CORR%20Issue%20documented%20here%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22https%3A%2F%2Fbugzilla.mozilla.org%2Fshow_bug.cgi%3Fid%3D465397%22%20href%3D%22https%3A%2F%2Fbugzilla.mozilla.org%2Fshow_bug.cgi%3Fid%3D465397%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fbugzilla.mozilla.org%2Fshow_bug.cgi%3Fid%3D465397%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22https%3A%2F%2Fbugzilla.mozilla.org%2Fshow_bug.cgi%3Fid%3D923067%22%20href%3D%22https%3A%2F%2Fbugzilla.mozilla.org%2Fshow_bug.cgi%3Fid%3D923067%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fbugzilla.mozilla.org%2Fshow_bug.cgi%3Fid%3D923067%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CA%20title%3D%22https%3A%2F%2Fgithub.com%2Fgoogle%2Fcaja%2Fissues%2F1878%22%20href%3D%22https%3A%2F%2Fgithub.com%2Fgoogle%2Fcaja%2Fissues%2F1878%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2Fgoogle%2Fcaja%2Fissues%2F1878%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHe%20was%20able%20to%20get%20by%20capturing%20the%20console%20log%3A%3C%2FP%3E%0A%3CP%3E%3CEM%3ECross-Origin%20Request%20Blocked%3A%20The%20Same%20Origin%20Policy%20disallows%20reading%20the%20remote%20resource%20at%20%3CA%20href%3D%22https%3A%2F%2Fworkspacename-ondemand.sql.azuresynapse.net%2Fdatabases%2Fmaster%2Fquery%3Fapi-version%3D2018-08-01-preview%26amp%3Bapplication%3DlistSqlOnDemandDatabases.%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fworkspacename-ondemand.sql.azuresynapse.net%2F.%3C%2FA%3E....%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%3CEM%3E(Reason%3A%20CORS%20request%20did%20not%20succeed).%202%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHar%20trace%20available%20on%20the%20developer%20tools%20can%20be%20a%20strong%20allied%20to%20get%20those%20very%20specific%20case%20scenarios%20and%20behaviors.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fdocs.microsoft.com%252Fen-us%252Fazure%252Fazure-portal%252Fcapture-browser-trace%26amp%3Bdata%3D02%257C01%257Clilem%2540microsoft.com%257Cb4a416bc301c47b5233008d86c53b405%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637378454185521175%26amp%3Bsdata%3DKrIWxGOQRt3PaFXINk2OAvLqD6Oovpu%252Be%252BeOwiNmjkk%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-portal%2Fcapture-browser-trace%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnother%20good%20post%20to%20take%20into%20consideration%20while%20troubleshooting%20this%20kind%20of%20issue%3A%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-synapse-analytics%2Fsynapse-workspace-pools-and-on-demand-inaccessible%2Fba-p%2F1403485%22%20target%3D%22_blank%22%3ESynapse%20Workspace%20Pools%20and%20On%20Demand%20Inaccessible%20-%20Microsoft%20Tech%20Community%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20is%20it!%3C%2FP%3E%0A%3CP%3ELiliam%20Leme%3C%2FP%3E%0A%3CP%3EUK%20Engineer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1993119%22%20slang%3D%22en-US%22%3E%3CP%3EFollowing%20some%20tips%20for%20troubleshooting%20issues%20that%20involve%20Synapse%20Studio.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1993119%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESynapse%20Studio%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESynapse%20Support%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

 

Following a concise summary of some tips for troubleshooting Synapse Studio:

Troubleshoot Synapse Studio connectivity - Azure Synapse Analytics | Microsoft Docs

Troubleshoot Synapse Studio - Azure Synapse Analytics | Microsoft Docs

 

Examples:

 

1) I am trying to load SQLDW on Synapse Studio and it shows not accessible. Keep in mind make questions to investigate the issue:

  • Do you in fact have permission to open SQLDW?
  • Is your SQL DW pause?
  • Can you connect from SSMS or Azure Data Studio?
  • Does the issue affect only your user or Any User?

Synapsestudioerror.png

Script to check permissions:

 

SELECT     DPUsers.name, 'has the '
           , permission_name
		   , 'permission on the item described as class = '
		   , class, 'id = '
		   , major_id
FROM sys.database_permissions AS DP
JOIN sys.database_principals AS DPUsers
    ON DP.grantee_principal_id = DPUsers.principal_id
	--where DPUsers.name like 'nameoftheuser'

 

 

You are trying to use SQL Serverless and the database is unreachable.

Almost the same questions:

  • Can you connect from SSMS or Azure Data Studio?
  • Does the issue affect only your user or Any User?
  • Does this issue affect only your user or any user?
  • If you switch browser can you connect?

SQLodUnre.png

 

In one of the cases, we had a situation while the customer was using firefox when he hit this CORR Issue documented here:

 https://bugzilla.mozilla.org/show_bug.cgi?id=465397

 https://bugzilla.mozilla.org/show_bug.cgi?id=923067 

https://github.com/google/caja/issues/1878

 

He was able to get by capturing the console log:

Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https://workspacename-ondemand.sql.azuresynapse.net/.....

(Reason: CORS request did not succeed). 2

 

Har trace available on the developer tools can be a strong allied to get those very specific case scenarios and behaviors.

 https://docs.microsoft.com/en-us/azure/azure-portal/capture-browser-trace

 

Another good post to take into consideration while troubleshooting this kind of issue:

Synapse Workspace Pools and On Demand Inaccessible - Microsoft Tech Community

 

 

That is it!

Liliam Leme

UK Engineer