I have a strange issue with SSRS 2005 , The issue is the report works fine from BIDS , but not from the Report Manager.
1. Report Manager is in server 'A'
2. Report Databases are in server 'B'
3. the server i am trying to connect is a different server , say 'C'
So, the data source which i have in my report is pointing to a database in server instance 'C'
the error i get in the report manager when i view it is :
"An error has occurred during report processing.
Cannot create a connection to data source 'ElektraRep'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors "
My try outs
1. i am able to login to the server and to the database with my logins(which i have used for the report) from SSMS.
2.Unable to connect to the server instace (Dev env) from the server , where i have report server.
How would i troubleshoot, breaking my heads
any help would be really appreciated