Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    1

    Unanswered: Connecting to Oracle through SSRS

    Hi,

    I have created a bunch of reports in MS Visual Studio and they run fine when I connect through VS. However when I deploy them (along with the same datasource) to my local Sql Server Reporting Server instances and try and run them I get the following error:
    * An error has occurred during report processing.
    Cannot create a connection to data source 'Checkpoint'.
    ORA-12154: TNS:could not resolve the connect identifier specified

    I can connect to the Oracle server through Squirrel SQL client also, so I think it is something to do with SSRS. Any help appreciated.

    Thanks

    Barry

  2. #2
    Join Date
    Nov 2006
    Location
    Indianapolis
    Posts
    90
    Is your report server Oracle client setup with the same TNS alias you used to develop the reports?

    Can you connect via sqlplus from the reporting server to Oracle?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •