Thursday, December 15, 2005

SQL 2000 Reporting Services Version Details

For 2000, the version information is located at the bottom of the main page
of your Report Server
RTM: 8.00.743.00
SP1 : 8.00.878.00
SP2 : 8.00.1038.00

The edition information is stored in the following registry key:
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\80\Reporting Services\ProductCode

Standard: {B19FEFE7-069D-4FC4-8FDF-19661EAB6CE4}
Enterprise: {33FE9EED-1976-4A51-A7AF-332D9BBB9400}
Developer: {2879CA50-1599-4F4B-B9EC-1110C1094C16}
Evaluation: {7C93251A-BFB4-4EB8-A57C-81B875BB12E4}

"Service Pack 1 Setup Error" during installation of Windows 2003 Service Pack 1

SYMPTOMS
When you run setup installation of Windows 2003 Service Pack 1 on Windows 2003 Data Center

you will prompt with a warning message:

"Service Pack 1 Setup Error

This Service Pack 1 has not been qualified by your hardware vendor for installation on this copy

of Windows Server 2003 Datacenter Server. Please contact your hardware vendor for additional

information on obtaining a Service Pack 1 that has been qualified for your system configuration".


CAUSE
The Windows 2003 Service Pack 1 Installation on Windows 2003 Data Center are block as default

to avoid installation without get full approved to this installation from your "OEM" hardware manufacture.


Note: Installation of Windows 2003 Service Pack 1 is recommended only after your

"OEM" hardware manufacture approved this installation. Skipping this stage may damage your system.


RESOLUTION
The Service Pack 1 installation on Windows 2003 is blocked unless you set a special

registry key.


To set this special registry key, follow the instructions bellow:


1. Go to" Start" -> "Run".

2. Write "Regedit" and press on "Enter" button.

3. Navigate to: "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\Windows Server 2003".

4. Right click and choose "New" -> "DWORD Value".

5.Name the new registry key: "DTCUpdate".

6. Double click on "DTCUpdate" and set its "Value data:" to "1".

7. Reboot the server.


CAUTION: Using Registry Editor incorrectly can cause serious problems that can require you to
reinstall the operating system. Microsoft cannot guarantee that problems resulting from incorrect
use of Registry Editor can be solved. Use Registry Editor at your own risk.
Make sure you back up the registry before making changes to it.


MORE INFORMATION
Overview of Windows Server 2003, Datacenter Edition

http://www.microsoft.com/windowsserver2003/evaluation/overview/datacenter.mspx

Windows Server 2003 Service Pack 1

http://www.microsoft.com/windowsserver2003/downloads/servicepacks/sp1/default.mspx