---
title: "Troubleshooting Database Connections"
canonical: "https://servicedesk.maxgeo.com/space/LC/1263206476/Troubleshooting%20Database%20Connections"
format: markdown
---
<u>**Objective:**</u>

1. If you have recently relocated the SQL Server or made other infrastructure changes - start at **Troubleshooting Step 2**.
2. If it usually works, but recently stopped working - start at **Troubleshooting Step 2**.
3. When in the "Database Connection" screen I get an error "Error connecting to the server" - start at **Troubleshooting Step 1**.

<u>**Useful info before you start:**</u>

There are 2 places that you connect to a database:

- <u>Database Manager</u> (Settings Menu - Database Management - Manage)
- <u>Reporter Manager</u> (Settings Menu - System Functions - "Report Database" field)

<u>**Troublehsooting:**</u>

1. If it connects correctly to the database in either the Database Manager or Reporter Manage, but not in the other, take a screenshot of the one that works, and compare it to the other.
  - If there are differences in the server name (section 1), refer **Cause 1**.
  - If there are differences in the log on credentials (section 2), refer **Cause 2**.
  - If there are differences in the database name (section 3), refer **Cause 3**.
  - For avoidance of doubt, it doesn't matter if "Display Name" is different.
2. Check the server name with your IT team to ensure it has been entered correctly.  The Server Name should be as it appears in SQL Management Studio.
  - If they are incorrect, refer **Cause 1**.
3. Check the database name with your IT team to ensure it has been entered correctly.  The Database Name should be as it appears in SQL Management Studio.
  - If they are incorrect, refer **Cause 3**.
4. Check with your IT whether or not credentials are as per Windows NT integrated security.
  - If yes, but this option has not been selected, refer **Cause 2**.
  - If no, but this option has been selected, refer **Cause 4**.

<u>**Cause:**</u>

1. You have entered an incorrect server name, so LeaseControl can't find it.  Refer **Solution 1**.
2. You have entered incorrect credentials, so LeaseControl is not authorised to connect to it.  Refer **Solution 2**.
3. You have entered an incorrect database, so LeaseControl can't find it.  Refer **Solution 1**.
4. You have entered incorrect credentials, so LeaseControl is not authorised to connect to it.  Refer **Solution 3**.

<u>**Solution:**</u>

1. Re-enter the details, noting that we recommend you Copy and Paste as per standard Microsoft functionality.
2. Select the option "Use Windows NT integrated security".
3. Get the specific username and password from your IT team.  We recommend you Copy and Paste as per standard Microsoft functionality.  Where database are locked down in such a manner, it is likely your Company policy will prohibit you from seeking assistance from Maxwell GeoServices without appropriate authorisation.