SQL Server Performance Forum – Threads Archive

cannot connect to data source

Hi all, I am trying to view report that i deployed to reporting service but when i try to view it, it gives error: An error has occurred during report processing.
Cannot create a connection to data source ‘INVC’.
For more information about this error navigate to the report server on the local server machine, or enable remote errors the datasource is ODBC: also if it try from \localhost
eports the getting this error:
An error has occurred during report processing.
Cannot create a connection to data source ‘datasourcename’.
For more information about this error navigate to the report server on the local server machine, or enable remote errors –> and if i try from \localhost
eportserver then getting this error: An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source ‘datasourcename’. (rsErrorOpeningConnection)
For more information about this error navigate to the report server on the local server machine, or enable remote errors Please help!! Thanks!!

Hi, Please give to me a complete deails.How do you configure the SQL Server Reporting Services. Amit Kumar
Mob.: 9873812005

SQL Server 2005 Books Online
Troubleshooting Report Processing Problems
http://msdn2.microsoft.com/en-us/library/ms157383.aspx http://msdn2.microsoft.com/en-us/library/ms156468.aspx
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

I have RS installed on same box of SQL server. I am trying to generate report which is pulling Oracle data from database. I have Oralce client installed as well as TNS file to connecting to database. but still when i try to view report on http:\servername:8080
eports!!! i get same error ssaying that : An error has occurred during report processing.
Cannot create a connection to data source ‘DT’.
For more information about this error navigate to the report server on the local server machine, or enable remote errors Thanks!!

See whether that port is opened on network, as it might be closed if a firewall is installed within your network. See Mohammed’s reference from BOL about this data connection error, if you try to run the report on the server locally, you should get more information about the error. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

I found the solution that i needed to have oracle client in order to make connection to datbase. thanks
for the help. really great ful for that. Thanks!!

Yes, thats the pain with having linked server to oracle. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

]]>