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 2008 Forums  Analysis Server and Reporting Services (2008)  The report connect to different servers not work

Author  Topic  zhangn Starting Member 29 Posts Posted - 2010-10-13 : 04:01:35 Hi all, I am new to SSRS 2008. I have two databases, one of them i got full premission and SSRS (let's call database A), and another one i only have the read access (let's call database B) . I tried to create a report using the data from the database B and deloy in database A. I have created a SSRS report. Everything works fine in the visual statio, i can design and preview the report. But when i deloy the report to the server A. It is shown successfully. But, when I tried to open it in IE, I have received the error message below: An error occurred during client rendering. An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'EFODSWeather'. (rsErrorOpeningConnection) 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. (rsOperationNotSupported) it is really odd, i have got the premission to access both databases. Is because I am using SQL express 2008 for my database A? i really hope someone can help me on this. I will be very appreciated. regards, Ning