May 12, 2010 at 7:00 am
I am trying to configure Reporting Services 2008 to use a Sql Server 2008 database on a remote server, but get the message:
The feature: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services.
Which edition(s) of Reporting Services support this feature?
May 12, 2010 at 7:20 am
A better question might be what version of SSRS are you currently using instead of what you need? I'm guessing that it's express with advanced services but it may be workgroup? As per Books Online (SQL Server's help files)...
If you are already familiar with Reporting Services in other editions, the following list to describes how Reporting Services works in SQL Server Express:
* All server components must be installed on a single server. You cannot use a remote server for the report server database.
* All data sources that provide data to reports must be from SQL Server relational databases are that are installed on the local SQL Server instance.
* All reports are processed on demand. Scheduled or unattended report processing is not supported.
* Data source connection strings and Reporting Services URLs have different default values in a SQL Server Express installation. SQL Server Express always installs as a named instance. Any URLs or connection strings must include the instance name. The following examples illustrate the syntax you should use.
According to BOL again
Remote and non-relational data source support
is only supported in Standard and Enterprise editions...
-Luke.
May 12, 2010 at 8:09 am
Thanks. I have to determine which edition we should buy.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply