How to connect to oracle from sql reporting services?

• Muralidharan Venkatraman-417748

  Mr or Mrs. 500

  Points: 546

  More actions

  June 5, 2009 at 3:32 am

  #205128

  Hi,

  I have sql server reporting services installed in one server. I have a developer developed reports and have deployed it in reporting services. The issue is, this report retrieves data from oracle.

  How do I configure the report to point to oracle?

  I went ahead and installed oracle10g client on the server.

  I added tnsnames and tested the pint and net assistant. everything is fine in the oracle side.

  When i added the dns names to this report, it does not recognize the connect string.

  Pls help.

• vsmurali111

  SSC Enthusiast

  Points: 150

  More actions

  June 5, 2009 at 6:13 am

  #1005185

  The error message i get is

  An error has occurred during report processing. (rsProcessingAborted)

  Cannot create a connection to data source 'test1'. (rsErrorOpeningConnection)

  For more information about this error navigate to the report server on the local server machine, or enable remote errors