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

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.