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

  • Article

Applies To: Operations Manager 2007 R2, Operations Manager 2007 SP1

Perform the following steps to configure a static port for the Operations Manager 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 root 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 Operations Manager database port number

  1. Log on to the computer hosting the Operations Manager database.

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

  3. In the SQL Server Configuration Manager dialog box, expand SQL Server 2005 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 2005 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 Operations Manager database, on the Windows desktop, click Start, point to Programs, point to Microsoft SQL Server 2005, 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 Operations Manager 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 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, a space, 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 root management server

  1. Log on to the computer hosting the root 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 a space, and then type the port number. For example, <comuter_name>\<instance>, <port number>.

  6. Click OK.