topic Re: How connect link from the Fabric to SSMS in Data Warehouse

How connect link from the Fabric to SSMS

GuillaumePower — Fri, 05 Jul 2024 13:57:53 GMT

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 ?

Re: How connect link from the Fabric to SSMS

frithjof_v — Sat, 06 Jul 2024 11:46:43 GMT

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/

Re: How connect link from the Fabric to SSMS

Anonymous — Mon, 08 Jul 2024 01:39:03 GMT

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!

Re: How connect link from the Fabric to SSMS

Anonymous — Thu, 18 Jul 2024 05:22:44 GMT

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