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. 

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