SQL 2000 scale out reporting services upgrade

  • Article

I was doing an upgrade for a scale out deployment for SQL Reporting Services 2000 and the servers were having only 1 NIC. After the upgrade finished I found that the reporting services is not working as it was not initialized. Here are the details:

Symptom:

Reporting services is not initialized on both nodes with an error "can't connect to the database server" in the event viewer, accordingly the report generation stopped.

Cause:

The encryption keys was corrupted on the reporting databases accordingly the nodes initialization can't succeed

Resolution:

  • From node1 delete the encryption key
  • Go to initialization page and make sure that node1 is listed as initialized and that no other nodes are listed
  • From node2 connect to the database source to create a new id in the database
  • Go back again to node 1 "physical server"
  • In the initialization page you should find the second node listed now
  • Select node2 and click initialize
  • If no errors displayed, make sure that both nodes are checked as initialized and the icon for the page is green and that the error is no longer appear in the event viewer

Note: to be able to initialize the second node from the first node while NLB is enabled we have to create the below registry key to enable the InterHost communication while NLB is enabled and configured as Unicast KB898867.

  • Click Start, click Run, type regedit, and then click OK.
  • Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\WLBS\Parameters\Interface\{GUID}Note The {GUID} placeholder represents the GUID of the particular NLB instance. You can use the ClusterIPAddress subkey in this hive to identify different NLB clusters.
  • On the Edit menu, click New, click DWord Value, and then add the following value data. Value name UnicastInterHostCommSupport Value 1
  • Note If you set the UnicastInterHostCommSupport registry entry to any non-zero value, Unicast InterHost Communication Support will be enabled.
  • Quit Registry Editor.
  • Open a command prompt, and then type the following command "NLB RELOAD"