How to Configure the Reporting Data Warehouse to Listen on a Specific TCP/IP Port

  • Article

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

Perform the following procedures to configure a static port for the Reporting data warehouse:

  • 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 dbo.MemberDatabase 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.

  • Edit the SQL Server Reporting Services settings.

To configure the Operations Manager database port number

  1. Log on the computer hosting the Reporting data warehouse.

  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 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. On 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 and instance for your Operations Manager database (for example, computer\INSTANCE1).

  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_DataWarehouse, and then click Open Table.

  6. In the results pane, scroll to the right to the column titled MainDatabaseServerName_<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\<instance>, <port>).

  8. Click File, and then click Exit.

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

  1. On the computer hosting the Reporting data warehouse, 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 DatabaseEngine.

  3. In the Server name list, type the server and instance 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 OperationsManagerDW, expand Tables, right-click dbo.MemberDatabase, and then click Open Table.

  6. In the results pane, scroll to the right to the column titled ServerName.

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

  8. Click File, and then click Exit.

To edit the registry on the Reporting 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 MicrosoftOperationsManager, expand 3.0, and then click Reporting.

  4. In the results pane, right-click DWDBInstance, 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.

To edit SQL Server Reporting Services

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

  2. Start Internet Explorer and connect to http://<computer name>/reports$<instance name>.

  3. Click the Contents tab.

  4. On the right side of the toolbar, click Show Details.

  5. Click Data Warehouse Main.

  6. In the Connection string text box, locate the line that reads source=<computer>\<instance>;initial.

  7. Append the instance name with a comma and a space, and then type the static port number. For example, source=<computer>\<instance>, <port>;initial.

  8. Click Apply, and then close the browser.