The only way of discovering the limits of the possible is to venture a little way past them into the impossible.

— Arthur C. Clarke               

Inside Time Matters: Exchange Sync Service

Here's a simple way to improve the reliability of your Time Matters Exchange synchronization. When the Exchange sync component of Time Matters is installed on the same server (computer) as the SQL Server, the Exchange sync service should be configured to depend on (wait for) the SQL Server. Some software applications have this functionality built in, for example, MobileTM does this for you automatically.

You can do this manually in just a few short steps. If you are comfortable modifying the registry, just follow these steps:

1) Determine the name of your SQL Server service, the default is MSSQLServer but if you have server instances, the service name is MSSQL$[instance_name] for example, MSSQL$SQLEXPRESS.

2) Launch the windows registry editor

3) Locate the Exchange Sync service entry as follows:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LNFOExchangeSync

4) Add a new registry key for the LNFOExchangeSync service:

Select Edit menu (or right-click service name), select New, Multi-String Value, name the new key "DependOnService"

5) Double-click the newly created registry key then enter the name of your SQL Server service (from step 1) in the entry and save.

The results should look something like this:


Windows Registry Dialog


Service Properties Dialog