Configure SQL Server

ADChangeTracker uses SQL Server database for its internal data storage, including storage of Change History. ADChangeTracker requires an SQL Server running SQL Server 2012 / 2008 / 2005 (Enterprise / Standard / Express editions) to connect and create a new application database. ADChangeTracker will connect to the specified SQL Server based on authentication mode and user credentials to manage its own application database. 

You can launch SQL Server settings to use by clicking Tools -> Options menu in the ADChangeTracker main application window, as shown below 

ADChangeTracker wizard will prompt for the SQL settings (Server name, authentication mode, user name and password) when the application is launched for the very first time. This setting can be accessed again from the Tools -> Configuration Settings... menu:

User Authentication

To connect to SQL Server, ADChangeTracker uses the relevant user accounts based on the authentication mode as listed below:

  1. Windows Authentication:
    In this method, ADChangeTracker uses the currently logged on user account while tracking changes using ‘Track Now’ or the Run as account while using ‘Track at scheduled intervals’.

  2. SQL Authentication:
    In this method, ADChangeTracker uses the specified SQL user account and password while tracking changes. ADChangeTracker stores the SQL user name and password as a user profile in 'Stored User Names and Passwords' applet for its usage. 

    Read User Profiles for more details.

    Note: ADChangeTracker expects the user account to have sufficient privileges to create, add to and delete database in the SQL server.

Database creation

ADChangeTracker creates databases in SQL Server as per the information outlined below:

ADChangeTracker creates a single application database in the default data storage location used by the SQL Server during application launch. ADChangeTracker uses the following naming convention:

ADChangeTracker-<COMPUTERNAME>, where COMPUTERNAME is the name of the computer running ADChangeTracker.

For example, if the computer running the ADChangeTracker is ‘CLIENT01’, ADChangeTracker creates 'ADChangeTracker-CLIENT01' with data ('ADChangeTracker-CLIENT01.mdf') and log ('ADChangeTracker-CLIENT01_log.LDF') files stored in the default SQL data folder in the SQL server (for example, C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data). 

Database cleanup

ADChangeTracker will delete the application database while uninstalling the ADChangeTracker application from the computer.