I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source.
Reports off the SQL Server Data Sources arerunning fine.
Can any one out there help me out on this. I will really appreaciate.
Regards,
Sam.
Assuming Oracle's client software is installed on the report server machine, it is most likely a directory permissions issue with Oracle's client software installation - see http://support.microsoft.com/?kbid=870668
-- Robert
|||Hi Robert,
Thanks for the guideline but I have done what is required as stated in the link and I still get the same error.
|||Do you deploy the reports on the same PC? Maybe your Server has a different Oracle installation or tnsnames.ora..For TESTING!! you could give "everyone" read/execute -access to your oracle-directory to eliminate permission-problems.
|||
It seems Permissions were my problem.
I assigned read/execute access to each of the Oracle Home Directory Folders and Subfolder to Network Service and it sorted out the problem
Thanks for all the Advise.
|||Hi there,
I have the same issue as described earlier in this thread. I have applied the security (Read and Execute) to all known Oracle instance directories to the Network Service account (which is being used for starting the Reporting Service) and I am still receiving the following error message:
I'm trying to use the Oracle instant client on my report server. it is setup correctly and I can connect via SQL+. I've modified reporting services to use Network Service as account for both windows and web services. And I've set permission on the OIC directory appropriately according to MS guidelines.
But same error, will not connect to the Oracle data source.
No comments:
Post a Comment