Troubleshoot Azure Database Connection Errors

At times you may encounter a message such as Database Connection failed to LT_Lite on Azure as AZ_LTS while connecting to an Azure database or opening Due Diligence Reports. The following troubleshooting steps are available.

Confirm your IP address

If you were previously able to connect, check that your IP address has not changed.

Most Azure databases are configured to only allow access from PCs within your network or that of LandTrack Systems.

If your IP address has changed (for example, due to moving to a different office or connecting via VPN from home), connection may fail. In this case, ask your IT department to coordinate with LandTrack Systems to make the necessary adjustments.

Enable Access to Port 1433

Ensure that Port 1433 is open for traffic. Access can be restricted to tcp:landtracker.database.windows.net,1433 if required.

This step is usually sufficient. If the connection issue persists, proceed with further troubleshooting steps.

Request Temporary Logon Details

Contact the LandTrack Systems Support team to request a temporary username and password, along with instructions to log in via SQL Server Management Studio.

Test Connection with SQL Server Management Studio

Using the provided logon details, connect to the database and run the following query:

Copy 
SELECT * FROM assets;

  • If the connection is successful, inform LandTrack Systems Support, who can investigate further.

  • If the connection fails, refer to the Microsoft page Troubleshooting Connectivity Issues with Microsoft Azure SQL Database for additional troubleshooting steps.