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:
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:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.