Article ID: 843369 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
This article describes late-breaking changes in Microsoft SQL Server 2000 Reporting Services Service Pack 1 (SP1) that are not documented in the SP1Readme.htm file. It also includes corrections to the original readme file.
The following additions should be included in the SP1_readme.htm file:
"Invalid cursor state" error messages when you work with the Table Designer in SQL Server Enterprise ManagerUsers who run Reporting Services on a Microsoft Windows Server 2003-based computer may have applied hotfix 8.00.0859 to run the report server under the Network Service account. If you have applied hotfix 8.00.0859, you may experience "Invalid cursor state" error messages when you work with the Table Designer in SQL Server Enterprise Manager.
To resolve this problem, install the hotfix that is included in the following Microsoft Knowledge Base article:
(http://support.microsoft.com/kb/831997/ )FIX: An invalid cursor state occurs after you apply Hotfix 8.00.0859 or later in SQL Server 2000
Updated installation instruction for Reporting Services SP1 on a Web farmIf you deployed Reporting Services on a Web farm, you must run Reporting Servicer SP1 Setup on each computer that hosts a report server instance. Take the servers offline until all of the report server nodes and the database are upgraded. To take the servers offline, stop Microsoft Internet Information Services (IIS) and the Report Server Windows service.
You can apply Reporting Services SP1 to the report server nodes in any order. The Setup program automatically upgrades the report server database to the Reporting Services SP1 schema.
After you upgrade a report server Web farm to Reporting Services SP1, you cannot use the Setup program to point a new report server instance to a Reporting Services SP1 report server database. Instead, follow these steps to add new report server nodes to a Reporting Services SP1 report server Web farm:
(http://support.microsoft.com/kb/839796/ )Bugs that are fixed by SQL Server 2000 Reporting Services service packs
(http://support.microsoft.com/kb/842440/ )How to obtain the latest service pack for SQL Server 2000 Reporting Services
Contact us for more help
Connect with Answer Desk for expert help.