Configuring SQL Server

When you choose to install SQL Server manually for either the Express or Advanced setup type of Sentinel LDK-EMS installation, you must use the specifications described in this section.

Enable TCP/IP

1. Open SQL Server Configuration Manager (Start > Programs > Microsoft SQL Server 2019 > SQL Server Configuration manager)

2. In the left pane, expand the node SQL Server 2019 Network Configuration.

3. Select Protocols for EMSDATABASE. The protocol names and their status appear in the right pane. (For the Advanced setup type, you can use any instance name.)

4. In the right pane, double-click TCP/IP. The TCP/IP Properties dialog box is displayed.

5. Under the Protocol tab, select Yes from the list against the Enabled context menu.

6. Restart the SQL Server (EMDATABASE) service.

Configure the TCP/IP Port

1. Right-click TCP/IP. In the context menu, select Properties. The TCP/IP Properties dialog is displayed.

2. Select the IP Addresses tab.

3.Expand the IPAll node and do the following:

a. Set the TCP Port field to blank. The SQL Server Express will not automatically choose another port when it restarts.

b. Set the desired port number in the TCP Dynamic Port field (for example, 1433).

c. Click OK.

4.Restart the SQL Server (EMDATABASE) service.