Forum Discussion

jacarmonaro's avatar
jacarmonaro
Frequent Visitor
2 years ago
Solved

Connecting to SQL end point in Fabric from SSMS

Hi folks, I'm having an odd error when I try to connect to the SQL analytics endpoint using SSMS. I am just copying and pasting the SQL connection string from Fabric into SSMS (server name). Then I u...
data warehouse
  • govindarajan_d's avatar
    govindarajan_d
    2 years ago

    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. 

jacarmonaro's avatar
jacarmonaro
Frequent Visitor
2 years ago

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's avatar
govindarajan_d
Icon for Super User rankSuper User
2 years ago

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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