[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Cannot connect to data source error

Posted on 2007-12-05
7
Medium Priority
?
1,610 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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
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…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

656 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