Skip to main content
InSource Solutions

TN Hist101 Setting up a dependency on SQL Server for the Historian.

Overview

 

Sometimes the Wonderware Historian configuration service may start up before Microsoft SQL Server is ready. This will cause the Historian to be non-functional. This article describes setting up a dependency on SQL Server in order to prevent the Historian configuration service from starting to soon.

Steps

 

1) Launch the Windows Registry Editor by going to Start \ Run  and entering regedit

Capture.JPG

2) Navigate to HKEY_LOCAL_MACHINE \ SYSTEM \ CurrentControlSet \ Services and find InSQLConfiguration

Capture2.JPG

3) Double click the DependOnService entry and enter MSSQLServer and click OK to close the edit window

Capture3.JPG

Capture4.JPG

4) Confirm the dependency by going to Start \ Run and entering services.msc

Capture5.JPG

 

5) Find the Wonderware Historian Configuration Server and right click it and go to properties

6) Click the dependencies tab and confirm SQL Server is in the list

Capture6.JPG

 

 

On the next reboot, the Historian Configuration Service should not try to start until SQL Server is started.