Anyone connected to Trimble's Spectrum Viewpoint SQL database in Fabric?

[mcorrell001]

I can connect easily with Sql Server Management Studio but not Fabric.  Not sure why?

[v-kathullac]

Hi @mcorrell001 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

Regards,

Chaithanya

[mcorrell001]

Hi, sorry.  I was out of office.  I found out that they need to whitelist the IP on their end.  

[v-kathullac · Accepted solution]

Hi @mcorrell001  ,

Thank you for reaching out to Microsoft Fabric Community Forum,Below are the few points which can resolve your issue.Let us know if you need any further assistance.

• Check the SQL Server connectivity from the gateway machine A successful SSMS connection from your local computer does not guarantee that Microsoft Fabric can access the database.
• If the Trimble Spectrum Viewpoint SQL Server is on-premises or behind a firewall/VPN, install and configure an On-premises Data Gateway on a machine that can connect to the SQL Server.
• From the gateway machine, verify that you can connect to the same SQL Server instance and database using SSMS.
• In Fabric, use the appropriate SQL Server connector and verify the server name, SQL Server instance, database name, port, and authentication method.
• If SSMS uses Windows Authentication, verify that the authentication method is supported by your Fabric connection. If possible, test with SQL Authentication using a dedicated account.
• Verify that the SQL Server firewall allows connections from the gateway machine and that the required TCP port (commonly 1433) is open.
• If you are using a named SQL Server instance, verify the instance and port configuration. Using a fixed TCP port is generally more reliable for gateway connectivity.
• Verify that the On-premises Data Gateway is online and updated and that the configured data source uses the correct server/database and credentials.
• Check the SQL Server TLS/encryption configuration if the connection fails even though network connectivity and credentials are correct. Older SQL Server/TLS configurations may not be compatible with Fabric.

Thanks,

Chaithanya.