Tuesday, March 31, 2009

Wednesday, March 4, 2009

Activate Reporting Services 2000 on Windows 2000

I installed SQL Server Reporting Services on Windows 2000. At the end it said I had to manually activate Reporting Services.

This is what I did:

C:\WINNT\Microsoft.NET\Framework\v1.1.4322>aspnet_regiis.exe –i

Then this….

C:\WINNT\Microsoft.NET\Framework\v1.1.4322>rsactivate -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config"

------------

If you had to restore a database that crashed, you'll need to restore the RSReportServer.config and then do a -r like this:

C:\WINNT\Microsoft.NET\Framework\v1.1.4322>rsactivate -c"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config" -r

Found the answer here:
http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=92&threadid=27885&enterthread=y