Monday, July 31, 2006

Repairing SQL Reporting Services 2000

Occasionally SQL Server Reporting Services 2000 seems to mess up and give you install errors, or permission errors. Listed below are 2 very good fixes which seem to fix the majority of issues:

1) run this command: RSActivate -c -r “C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config”

2) try this knowledgebase article: http://support.microsoft.com/kb/887787

enjoy...

Monday, July 24, 2006

Internet SQL Reporting Server 2000

This is far too complex and poorly documented for my liking!

Microsoft recomend that you add this tag to the Reportserver Virtual Dir rswebapplication.config file:

www.domainName.com/reportServer

HOWEVER This is much easier

Delete the info in the section of rswebapplication.config

/ReportServer

and ensure that the ReportServer virtual directory in IIS is pointing to:

"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager"

how good is that!