Hello,
I was working on SSRS 2005 as part of SQL Server 2005 Express Edition with Advanced Services Sp1. I successfully developed a custom reporting application. It was working fine. Then I installed SQL Server 2008 on the machine. Corresponding changes in the database connection string, data source specification etc have been made.
Now the application fails to display the report, showing
"An error occurred during rendering of the report. An error has been occurred during Report Processing. Cannot create a connection to datasource <dsname>. A network related or instance specific error occurred while establishing a connection to SQL Server. The Server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. [Provider: SQL Network Interfaces. error 26 - Error locating server/instance specified]"
But it can list the reports and data sources deployed to the report server. Also deployment of new data sources and reports is working without any problem. Only report rendering is failing.
Can anyone help me?
Thanks in advance.
Zainul Abid
|