SSRS Configuration Guidelines

• Ensure SQL Server is installed with Reporting Services.
• Ensure that you have prepared Reporting Services for K2. For more information, see the Kaseya knowledge base.
• If SQL Server 2005 x64 is installed locally on Windows Server 2003 x64 (IIS 6), you need to uninstall the x64 SSRS and install x86 SSRS.  Review the following knowledge base article: Configuring Kaseya VSA 6.x with Windows Server 2003 x64 running SQL Server 2005 x64
• Other articles that may be of some interest include:
  • MS Reporting Services 2008 Deployment  
  • MS Reporting Services 2005 Deployment
  • Installing and Configuring SQL Server 2005 Reporting Services
• Verify Reporting Services installation by browsing to the Report Server. This URL is required by the VSA installation.
  • Assuming a localhost installation, use http://localhost/ReportServer. You should get a Reporting Services home page without needing to authenticate.
  • If SQL is on a separate server, this page needs to be accessible from the Kaseya Server using http://<SSRS-system-name>/ReportServer.
  • If you are not using the default instance, the URL will become http://localhost/<SSRS-system-name$InstanceName>.

  Note: See Specifying the SSRS URL.