Change the Database Connection String

Administrators may need to update SmarterTrack's database connection string after reinstalling SQL or moving to a new server. Database connection string settings are initially configured while running the Database Connection Wizard during the installation process but can be modified at any time.

NOTE: Following these steps will prompt you to re-enter your primary administrator's login credentials and database connection information. This will not delete any of your existing data, with the exception of the default SMTP settings that are stored in the SystemSettings.xml file. Default SMTP settings should be re-entered upon completing these steps. 

Applies to SmarterTrack 11.x-12.x

Run the Database Connection Wizard
The Database Connection Wizard will walk you through the connection and initialization of the database. Follow these steps to run the wizard again:

  1. Stop your SmarterTrack application pool.
  2. Delete SystemSettings.xml in your installation directory's App_Data\Config folder. The default location is [C:\Program Files (x86)\SmarterTools\SmarterTrack\MRS\App_Data\Config].
  3. Start your SmarterTrack application pool.
  4. Log in to SmarterTrack as the primary administrator.
  5. The Database Connection Wizard will automatically run. NOTE: If you are prompted to complete the Company Setup Wizard, click Next to bypass the company setup. SmarterTrack will load your existing company settings from its database.

Once you have completed the Database Connection Wizard, your database will be initialized and the system will automatically log you in to the portal as the primary administrator.

Applies to SmarterTrack 6.x-10.x

Change the database settings from the management interface
Follow these steps to update the database settings from the management interface:

  1. Log into the SmarterTrack management interface as an administrator.
  2. Click the settings icon.
  3. Expand the System Settings and Setup folders in the navigation pane.
  4. Click Database Settings.
  5. Complete the following required fields: Server Type, Server Name, Authentication, Username, Password, Database Name, Table Name Prefix. NOTE: SmarterTools recommends leaving the table name prefix as the default value (st_).
  6. Click Test Settings to make sure all settings are correct.
  7. Click Save.

Run the Database Connection Wizard
The Database Connection Wizard will walk you through the connection and initialization of the database. Follow these steps to run the wizard again:

  1. Stop your SmarterTrack application pool.
  2. Delete SystemSettings.xml in your installation directory's App_Data\Config folder. The default location is [C:\Program Files (x86)\SmarterTools\SmarterTrack\MRS\App_Data\Config].
  3. Start your SmarterTrack application pool.
  4. Log into SmarterTrack as the primary administrator.
  5. The Database Connection Wizard will automatically run. NOTE: If you are prompted to complete the Company Setup Wizard, click Next to bypass the company setup. SmarterTrack will load your existing company settings from its database.

Once you have completed the Database Connection Wizard, your database will be initialized and the system will automatically log you in to the portal as the primary administrator.

For more information, refer to the Database Settings section of the SmarterTrack Online Help.

 

Learn more about the SmarterTrack online help desk and how you can improve your overall customer service.

Feedback

Add Feedback
Hi I noticed that you do not set the Application name in the Connection String. It is left to the default ".Net SqlClient Data Provider". Because it is stored encrypted, I cant add the Application name setting. Could you add this setting in a new version of the product?
Cameron Townshend (February 22, 2016 at 4:29 PM)
Hi Cameron! Thanks for the feedback. Please make this request in the Community as a Proposed Idea. At the moment, as you mentioned, it's not possible to modify the application name. However, this may be something our developers could add to a later version. Posting in the Community allows other users to share their agreement and help get it in front of the developers.
Andrea Rogers (February 23, 2016 at 8:30 AM)

Add Feedback