Checking for SQL Server Agent - Honeywell DOC4000 - 7.3 - Installation & Upgrade - Intergraph

DOC4000 Installation Guide

Language
English
Product
Honeywell DOC4000
Search by Category
Installation & Upgrade
PAS Version
7.3

Successful SQL Server maintenance jobs have the following requirements for the SQL Server Agent Service:

  • Service must be active and running

  • Service must run under a Windows user account that has the appropriate permissions to perform duties on the DOC4000 database and server.

  • Ensure service runs under the Network Service (also known as NT Authority\Network Service) account,

  • Service should be configured to start automatically.

To check these items:

  1. Open Windows Services and select SQL Server Agent in the middle pane.

  2. Click More Actions > Properties in the right pane.

  3. Set the Startup type to Automatic.

  4. Set the Service status to Running.

  5. Click the Log On tab.

  6. Set the account to Network Service. If not already set, click the Browse button, add Network Service, and click OK.

  7. Click OK to close the SQL Server Agent Properties window.