Connect to a Database

Permissions note: You need the db_owner role membership for the connected database.

To add a database connection:

  1. On the Dashboard, in the Settings menu, click Manage Database Connections.

    The Manage DB Connections screen displays.

    Note: LandTracker must have at least one database connection configured. During installation, a database connection record is created based on your computer name and a specific SQL Server instance for LandTracker (MSSQLLT). However, this SQL Server instance is not created during installation. You can delete this placeholder database connection record after you have configured your actual database connection.

  2. Enter database details:
    1. Click Add New Row in the data grid.
    2. Complete the following fields with information provided by LandTrack Systems or your company's LandTracker administrator.
      • Name
      • Server
      • DBName
      • UserName
      • Password

      3. Note: If you are using a SQL Server with trusted Windows authentication, do not enter a UserName and Password.

  3. To set this database as your default database, click Set as Default.

    IsDefault is set to True for the database.

  4. Click Test Connection.

    A connection status message displays.

  5. Click OK.
  6. Click Switch To.

    A connection confirmation message displays and the Status Bar displays the current database, server and user name.

    If you are connected to your default database, the background colour of the Dashboard is pale blue. If you are connected to a non-default database, the background colour of the Dashboard is salmon orange.

  7. Click OK.
  8. Click Save and Close.

To test whether you can connect to a database:

  1. On the Dashboard, in the Settings menu, click Manage Database Connections.

    The Manage DB Connections screen displays.

  2. Select the database in the data grid.
  3. Click Test Connection.

    A connection status message displays.

  4. Click OK.

To switch to a different database:

  1. On the Dashboard, in the Settings menu, click Manage Database Connections.

    The Manage DB Connections screen displays.

  2. Select the database in the data grid.
  3. Click Switch To.

    A connection confirmation message displays.

  4. Click OK.

    The Status Bar displays the currently connected database.

To set a database as your default database:

  1. On the Dashboard, in the Settings menu, click Manage Database Connections.

    The Manage DB Connections screen displays.

  2. Select the database in the data grid.
  3. Click Set as Default.

    IsDefault is set to True for the database.

  4. Click Save or Save and Close.