• Article

How to Configure the Operations Manager Database to Listen on a Specific TCP/IP Port

 

Updated: October 7, 2016

Applies To: System Center 2012 R2 Operations Manager, System Center 2012 - Operations Manager, System Center 2012 SP1 - Operations Manager

Perform the following steps to configure a static port for the operational database:

  • Use the SQL Server Configuration Manager to disable dynamic port addressing, specify a static port, disable and stop the SQL Server Browser service, and then restart the SQL Server <Instance> service.

  • Edit the dbo.MT_ManagementGroup table with the static port number.

  • Edit the registry to configure the static port number on the management server.

    Warning

    Incorrectly editing the registry can severely damage your system. Before making changes to the registry, you should back up any important data.

To configure the operational database port number

  1. Log on to the computer hosting the operational database.

  2. On the Windows desktop, click Start, point to Programs, point to the appropriate offering of Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager.

  3. In the SQL Server Configuration Manager dialog box, expand SQL Server Network Configuration, and then click Protocols for <INSTANCE>.

  4. In the results pane, right-click TCP/IP, and then click Properties.

  5. In the TCP/IP Properties dialog box, click the IP Addresses tab.

  6. Several IP addresses appear in the format IP1, IP2, up to IPAll. One of these is for the IP address of the loopback adapter, 127.0.0.1. Additional IP addresses appear for each IP address on the computer. Expand IP1, IP2, up to IPAll.

  7. For the IPn areas, if the TCP Dynamic Ports dialog box contains a 0, indicating the Database Engine is listening on dynamic ports, delete the 0.

  8. In the IPAll area, if the TCP Dynamic Ports dialog box contains a port number (which indicates the dynamic port number that was assigned), delete the port number.

  9. In the IPAll area, in the TCP Port dialog box, enter the static port number you want to use, and then click OK.

  10. In the SQL Server Configuration Manager dialog box, click SQL Server Services.

  11. In the SQL Server Configuration Manager results pane, right-click SQL Server Browser, and select Properties.

  12. In the SQL Server Browser Properties dialog box, click the Service tab.

  13. In the Service tab, click Start Mode. In the Start Mode list, click Disabled, and then click OK.

  14. In the SQL Server Configuration Manager results pane, right-click SQL Server Browser, and then click Stop.

  15. In the results pane, right-click SQL Server (<instance name>), and then click Restart.

  16. Close the SQL Server Configuration Manager.

To enter the SQL Server port number into the dbo.MT_ManagementGroup table

  1. On the computer hosting the operational database, on the Windows desktop, click Start, point to Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.

  2. In the Connect to Server dialog box, in the Server type list, select Database Engine.

  3. In the Server name list, type the server name, instance, and port number for your operational database (for example, computer\<instance>).

  4. In the Authentication list, select Windows Authentication, and then click Connect.

  5. In the Object Explorer pane, expand Databases, expand the operational database (for example, OperationsManager), expand Tables, right-click dbo.MT_ManagementGroup, and then click Open Table.

  6. In the results pane, scroll to the right to the column titled SQLServerName_<guid>.

  7. In the first row, enter computer\<instance> followed by a comma, and then the SQL Server port number (for example, computer\INSTANCE1,<port>).

  8. Click File, and then click Exit.

To edit the registry on the management server

  1. Log on to the computer hosting the management server.

  2. On the Windows desktop, click Start, click Run, type regedit, and then click OK.

  3. On the Registry Editor page, expand HKEY_LOCAL_MACHINE, expand SOFTWARE, expand Microsoft, expand Microsoft Operations Manager, expand 3.0, and then click Setup.

  4. In the results pane, right-click DatabaseServerName, and then click Modify.

  5. In the Edit String dialog box, in the Value data text box, append the database server name entry with a comma, and then type the port number. For example, <comuter_name>\<instance>,<port number>.

  6. Click OK.