Installation

Run The Installer



During the installation this dialog will show up. Enter the service account you want to use. This account should preferably be an account that can access the SQL Server.

Configuration

The service is automatically started and you need to set up the connectionstring. By default the connection is authenticated with the account used to run the service, if you want to change this do so in the connectionstring.

The connectionstring and other settings are found in the file "SQL Keep Alive.exe.config" located in the folder "C:\Program Files (x86)\Herlitz\SQL Keep Alive". Open the file in notepad or any other text editor


Connectionstring
See the msdn documentation at http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring.aspx
<add name="sql" connectionString="server=sql02cluster;Trusted_Connection=yes;database=master;connection timeout=30;Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>

WriteLog
Set what you want to log, valid options are All, None and Errors
<add key="WriteLog" value="Errors" />
  • All: This will log both successful and unsuccessful events
  • None: This wont log anything, use this if you only want to use this utility to poke the SQL Server at certain times
  • Errors: Only log exceptions

UpdateInterval
Set the interval you want to test the SQL Server, default is 60 seconds
<add key="UpdateInterval" value="60" />

Activating Configuration Changes

The changes isn't activated directly, you have to restart the service. Open the Local services application and restart the SQL Server Keep Alive Service

Checking health status

Open the event viewer and look for entries with source "SQL Server Keep Alive Service".

This view may vary a lot depending on your logging settings

Last edited Aug 23, 2012 at 7:15 PM by EricHerlitz, version 8

Comments

No comments yet.