2.4 Configuring Microsoft SQL Server

Before installing Sentinel Agent Manager, NetIQ recommends that you configure Microsoft SQL Server to allow Sentinel Agent Manager components that use SQL Server to function properly.

2.4.1 Enabling and Starting the SQL Server Browser

NetIQ also recommends enabling and starting the SQL Server Browser in most SQL Server installations. Sentinel Agent Manager uses the SQL Server Browser to resolve named instances of SQL Server.

If you choose not to enable or start the SQL Server Browser on your database server, when you install Sentinel Agent Manager, you must specify both the SQL Server computer name in NetBIOS format and the port used by Microsoft SQL Server.

For more information about specifying databases names and ports during installation, see the setup program Help.

To enable and start the SQL Server Browser:

  1. Log on to the database or reporting server using an account that is a member of the Microsoft SQL Server sysadmin role. For more information about SQL permissions, see the Microsoft SQL Server Help.

  2. Start SQL Server Configuration Manager, located in either the Microsoft SQL Server 2017, Microsoft SQL Server 2016, Microsoft SQL Server 2014, or Microsoft SQL Server 2012 program group.

  3. (Conditional) If your database server uses SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, and SQL Server 2012 Express in the left pane, click SQL Server Services.

  4. In the right pane, click SQL Server Browser.

  5. On the Action menu, click Properties.

  6. Click the Service tab.

  7. Click Start Mode and select Automatic.

  8. Click Apply and then click OK.

  9. (Conditional) If the SQL Server Browser is stopped, complete the following steps:

    1. In the right pane, click SQL Server Browser.

    2. On the Action menu, click Start.

  10. Close SQL Server Configuration Manager.