[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Cannot connect to data source error

Posted on 2007-12-05
7
Medium Priority
?
1,611 Views
Last Modified: 2012-08-14
We have a new installation of sql server 2005 reporting services.
we can deploy reports without a problem users can connect to report server
but when they try to run reports they get this error msg.

An error has occurred during report processing.
Cannot create a connection to data source 'xxxxx'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors

in reporting services the datasource credentials are saved on the server
0
Comment
Question by:deNZity
  • 3
  • 2
6 Comments
 
LVL 18

Expert Comment

by:Yveau
ID: 20422951
Looks like you saved the wrong credentials.
Try a trace with the SQL profiler to see who logs on and who fails to log in ...

Is all installed on one machine ? Two separate machine for RS and SQL ?
Windows credentials ? Checked the 'use as windows credentials' checkbox or did you use SQL authentication in the shared data source ?

Hope this helps ...
0
 

Author Comment

by:deNZity
ID: 20424515
All is installed on one machine.
Data sources use oracle username and pword.

when I access reports on via a browser on the server I get the following eror message

An error has occurred during report processing.
Cannot create a connection to data source 'Oracare'.
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

Oracle client 10.2.0 is installed on the server so don't understand his msg
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20430391
OK, so you are connecting to an Oracle instance ... never tried that before, but should be the same as connecting to a SQL Server machine.
What Oracle version is running ? Strange that if a 10.2.0 server is installed, the message tells you to install client 8.1.7 or higher ... I would expect that it would ask for client 10.2.0 ... ?

Try setting up a DSN using the credentials and than fill in the DSN as connection string ... what does your connection string look like ?

Hope this helps ...
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 

Accepted Solution

by:
deNZity earned 0 total points
ID: 20445633
Restarted IIS and ReportingServices, and everything was fine ?
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20451667
OK, one of those undocumented features ...

Glad it's solved, don't forget to close the Q.
0
 
LVL 1

Expert Comment

by:Vee_Mod
ID: 20708729
Closed, 500 points refunded.
Vee_Mod
Community Support Moderator
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Loops Section Overview

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question