Comprehensive Guide to Establishing MSSQL Server Dependency in Smarter Track

Smarter Track requires a database for data storage and access to the SQL database for licensing verification. Setting this dependency ensures Smarter Track can connect to SQL Server after a system restart.

Note: Smarter Track startup is not affected by the dependency between Smarter Track and SQL on different servers. Ensure the SQL server is online before starting Smarter Track, and an IIS reset should resync it to the remote database.

a) How do I set up the Smarter Track dependency for MSSQL Server ?

1. First, back up the Windows registry.

Note: To learn how to backup and modify registry keys, refer to Microsoft Help and Support.

2. Then, open the Registry Editor.

3. After that, find the “HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\W3SVC” folder.

4. Next, add MSSQLSERVER to the DependOnService key.

5. Finally, close the Registry Editor.