Solved

Cannot connect to data source error

Posted on 2007-12-05
7
1,604 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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 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