How connect link from the Fabric to SSMS

[GuillaumePower]

Hello, I've this bug on my SSMS when I want to connect Fabric to SSMS, the More Info in English is The size  of the value for the key  "data source" oversize the limit of 128.

Do you think that something is wrong when I use this  link, I ve tried too to use the URL link.

Do you have an  idea about  this ?

[frithjof_v · Accepted solution]

I think you need to use the SQL Connection String instead.

If using Fabric Data Warehouse:

https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity

If using Fabric Lakehouse SQL Analytics Endpoint:

https://www.reddit.com/r/AZURE/comments/14fz6lj/how_to_connect_microsoft_fabric_lakehouse_sql/

[Anonymous · Accepted solution]

Hi @GuillaumePower ,

I am contacting you to find out if your problem has been resolved?

Were my and frithjof_v 's answers helpful to you? Could I trouble you to accept the answer that helped you as a solution.

If our answer was not helpful and you still solved the problem, I would like you to share your solution, which will be of great help to users experiencing the same problem.

Thank you in advance and please feel free to contact me if you have any questions.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

Hi @GuillaumePower ,

Thanks for the reply from frithjof_v .

In SQL Server Management Studio (SSMS), you will usually get an error when you try to use data that is larger than the maximum size that SSMS can handle for a particular field or parameter.

In addition to the method provided by frithjof_v , you can also try to shorten the value of the "Data Source" key. If possible, use a shorter alias or other method to refer to the data source.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[frithjof_v · Accepted solution]

I think you need to use the SQL Connection String instead.

If using Fabric Data Warehouse:

https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity

If using Fabric Lakehouse SQL Analytics Endpoint:

https://www.reddit.com/r/AZURE/comments/14fz6lj/how_to_connect_microsoft_fabric_lakehouse_sql/