Reporting services cant connect to remote server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Reporting services cant connect to remote server

Author

Topic

PeterSp
Starting Member

1 Post

Posted - 2009-05-26 : 07:38:39

Hello

Im using SQL Server 2005 Workgroup and Reporting Services. Most of my reports connect to local server but one need remote server connection. I made new data source and configure report but when I wish render report I get error:

An error has occurred during report processing.
Cannot create a connection to data source '...'.
The feature: "The edition of Reporting Services that you are using requires that you use local SQL Server relational databases for report data sources and the report server database." is not supported in this edition of Reporting Services.

Server version is:
9.00.3068.00 SP2 Workgroup Edition

On my developer machine where is Developer edition (9.00.3042 SP2) works fine.

Any suggestion?

savior faire
Posting Yak Master

194 Posts

Posted - 2009-05-26 : 09:22:04

The developer edition is the same as the Enterprise Edition, only that it is licensed for development.
I am not familiar with the detailed features of the Workgroup Edition, but judging from the error message it seems that it only allows local connections. I suggest checking the Books Online Documentation that you should have installed at your installation.

Talk sense to a fool and he calls you foolish.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources