Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS 2008 Report manager ORA-12154 Expand / Collapse
Author
Message
Posted Wednesday, May 27, 2009 8:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 13, 2009 8:15 AM
Points: 1, Visits: 18
Hi ALL,

I ve been trying to resolve this problem for a long time.
We have ssrs 2008 on Windows 2003 machine. Some of the reports are based on SSAS 2008 cubes and some need reporting from oracle views.
The problem is with the reports from Oracle Views, I am able to see the data and execute the report just fine when in Report desiger. When the same report is deployed in report Manager I am geting this error.


An error occurred during client rendering.
An error has occurred during report processing.
Cannot create a connection to data source 'xxx'.
ORA-12154: TNS:could not resolve the connect identifier specified


I would really appreciate if anyone who is aware of the problem can suggest me on what might be the next thing to try and see!
Post #724201
Posted Thursday, May 28, 2009 7:15 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 11:21 PM
Points: 138, Visits: 370
I've had similar errors when the Oracle Client tnsnames.ora on the report server specifies different connection info to that of the tnsnames.ora on my development machine. Do yours match?
Post #725553
Posted Monday, July 27, 2009 10:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Yesterday @ 12:58 PM
Points: 1, Visits: 40
have you found a resolution to this? I am having the same issue.
Post #760219
Posted Thursday, August 29, 2013 8:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 28, 2014 4:58 AM
Points: 3, Visits: 122
Any fixes on this issue - I am having the same problem with SSRS!!
Post #1489734
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse