Troubleshooting Synapse Studio tips

by | Dec 16, 2020 | Technology | 0 comments

This article is contributed. See the original author and article here.

 


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

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.

Submit a Comment