Reporting service configuration in distributed environment

Hi,

Please let me know if the following server configuration is possible?

SQL Server Database Services on machine #1

Analysis Services and Reporting Services 2005 on machine #2 (without SQL Server Database Services)

Post installation, need to setup Reporting services configuration. In that, within Database Setup, point to database installed on machine #1.

I am facing problem in pointing to remote database.

Awaiting some reply.

Thanks!

Hi RSUser08,

This configuration for SQL engine and Reporting Services is supported:

- machine 1: SQL Server Database Services

- machine 2: Reporting Services files-only installation (which means a named instance)

I would suggest to install on both machines the SQL Server Management Tools.

On the machine 1 you could use the tool SQL Server Surface Area Configuration for configuring your engine service to accept both local and remote connections. Be sure you restart the SQL engine service after you made this configuration change.

On the machine 2 you could use the configuration tool for Reporting Services to configure your files-only instance. For the database setup, you could connect from machine 2 to machine 1 and after this you can create a new catalog or choose from the drop-down list an existing catalog on the machine 1. Be sure you press apply after any option you chose.

If you encounter any problems during the database creation or choosing a previous created database, please let me know. In this case please let me know also what version and edition of SQL 2005 you are using.

Mihaela

|||

Thanks a lott Mihaela!

We are facing problem in the database setup of Reporting Service configuration.

Following is our machine configuration details:

We are using SQL Server 2005 Standard Edition. (Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) )

1: Machine #1 = SQL Server Database - Database Services only installed. No IIS.

2: Machine #2 = Analysis Services & Reporting Services. Used SQL Server 2005 Standard Edition CD to install only those 2 services. This machine has IIS 6.0 installed.

3:All the services are installed using the local Administrator account (as opposed to using a Windows domain account with administator privileges). The services are running under Local System account.

4: In Database Setup configuration, pointed to remote database. On click of Apply button we got the following error:

ReportServicesConfigUI.WMIProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation.
> System.Runtime.InteropServices.COMException (0x800706B3): The RPC server is not listening. (Exception from HRESULT: 0x800706B3)
End of inner exception stack trace
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)

The only reason we guess is that all the services needs to be installed and run under a domain account.

Please do let me know the exact reason for this failure.

Thanks once again!