2.3 Installing Microsoft SQL Server

Install Microsoft SQL Server on the database server. For the list of supported Microsoft SQL Server versions, see System Requirements.

Sentinel Agent Manager supports clustered and named instances of the Standard and Enterprise versions of Microsoft SQL Server. You can specify named instances during the database server installation.

Whether you install Microsoft SQL Server or use an existing Microsoft SQL Server implementation, ensure the implementation supports the following requirements:

  • TCP/IP network protocol. By default, the Microsoft SQL Server setup program installs and configures the Net‑Libraries to listen and respond to clients using the TCP/IP protocol. Ensure you configure Microsoft SQL Server on the database server and reporting server to use TCP/IP as the primary protocol. For more information about protocol support or enabling TCP/IP, see the Microsoft SQL Server documentation.

  • Audit level set to None or Failure

  • Dictionary order, case‑insensitive sort order

WARNING:Ensure you install all Microsoft SQL Server components at once. If you install some components during the initial setup and try to add other Microsoft SQL Server components later, your Microsoft SQL Server installation may not function properly.

NOTE:The Sentinel Agent Manager setup program uses OLE Automation to validate the file system during database installations on the database server. If OLE Automation is not already “on,” Sentinel Agent Manager turns it “on” for the installation, and then turns it “off” when installation is complete.

For more information about installing Microsoft SQL Server, see the Microsoft SQL Server documentation.