Forum Discussion
Connecting to SQL end point in Fabric from SSMS
Hi jacarmonaro,
My bad. It is Error list and Output
Also, while connecting to the SQL endpoint, try giving the exact lakehouse name as database by going to options.
In terms of permissions, I guess you are good. It's just that the workspace can have multiple lakehouses/warehouses to which you might not have access.
Super UserHi jacarmonaro ,
In SSMS, Go to View -> Select Error messages and output box. Now try to connect to the SQL endpoint and look at the queries that are fired.
When I connected my lakehouse, I can see that in the backend, a temp table is created and then names of the databases are inserted into that table.
You might not have the access to read the data at that level, you can try specifiying a particular database to connect to, which in this case a lakehouse/warehouse name.
The endpoint is the same across the workspace. So in case you were provided access to only one lakehouse/warehouse in the workspace, then I think that might be the reason you are getting this issue.
Thank you for replying. I have not been able to find this option is SSMS: View -> Select Error messages and output box. Can you double-check the option name, please?
The owner of the lakehouse also assigned me as owner, but I am still having the same issue. Any idea of the type of permission I should get?
Thank you again!
- govindarajan_d
Hi jacarmonaro,
My bad. It is Error list and Output
Also, while connecting to the SQL endpoint, try giving the exact lakehouse name as database by going to options.
In terms of permissions, I guess you are good. It's just that the workspace can have multiple lakehouses/warehouses to which you might not have access.
Hi jacarmonaro
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks