topic Re: Error Connecting to Fabric SQL Endpoint using SSMS and Azure Data Studio in Developer

Error Connecting to Fabric SQL Endpoint using SSMS and Azure Data Studio

CoulterJames2 — Fri, 19 Apr 2024 13:59:46 GMT

I have signed up for a Fabric trial and wanted to connect to a Lakehouse SQL Analytics endpoint through SQL Server Management Studio on my local machine but I get the "pre-login handshake" error as follows:

I understood that the solution to this issue was to tick the "Trust Server Certificate" box on the connection dialog, which I have done:

I have also specified the database name in the Connection Properties tab:

I get the same error messages when connecting to the Lakehouse from Azure Data Studio.

I believe that you are meant to be able to connect to a SQL endpoint in Fabric from client tools such as SSMS and ADS, so why isn't this working?

Re: Error Connecting to Fabric SQL Endpoint using SSMS and Azure Data Studio

Anonymous — Mon, 22 Apr 2024 02:26:31 GMT

HI @CoulterJames2,

Have you tried or test with a real fabric license instead of trial versions?

AFAIK, trial version only provided part of features for user to do test with fabric features. It means in this version it may not active and generated all the backend configuration/proprieties and correspond contents that similar like the general version. For the backend configuration/properties, they may affect the verification/authorization processing steps.

BTW, you can also take a look at the XMLA endpoint feature and how it use it if helps with your scenario:

Semantic model connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

Re: Error Connecting to Fabric SQL Endpoint using SSMS and Azure Data Studio

CoulterJames2 — Mon, 22 Apr 2024 11:19:26 GMT

I have a colleague who can connect to a SQL endpoint in Fabric using a trial subscription and he has version 18.11 of SSMS whereas I am using SSMS version 20.1 and I cannot connect. So it is not due to a limitation in the Fabric trial, it must be due to an authentication or configuration error elsewhere.