?
Solved

Cannot connect to data source error

Posted on 2007-12-05
7
Medium Priority
?
1,609 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

770 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