Following a concise summary of some tips for troubleshooting Synapse Studio:
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:
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.
Another good post to take into consideration while troubleshooting this kind of issue:
That is it!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.