SQL Server Performance

cannot connect to data source

Discussion in 'SQL Server 2005 Reporting Services' started by PatDeV, Apr 27, 2007.

  1. PatDeV New Member

    Hi all,

    I am trying to view report that i deployed to reporting service but when i try to view it, it gives error:

    An error has occurred during report processing.
    Cannot create a connection to data source 'INVC'.
    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    the datasource is ODBC:

    also if it try from \localhost
    eports the getting this error:
    An error has occurred during report processing.
    Cannot create a connection to data source 'datasourcename'.
    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    --> and if i try from \localhost
    eportserver then getting this error:

    An error has occurred during report processing. (rsProcessingAborted)
    Cannot create a connection to data source 'datasourcename'. (rsErrorOpeningConnection)
    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    Please help!!

    Thanks!!
  2. amitkumaradmin New Member

    Hi,

    Please give to me a complete deails.How do you configure the SQL Server Reporting Services.



    Amit Kumar
    Mob.: 9873812005
  3. MohammedU New Member

  4. PatDeV New Member

    I have RS installed on same box of SQL server. I am trying to generate report which is pulling Oracle data from database. I have Oralce client installed as well as TNS file to connecting to database. but still when i try to view report on http:\servername:8080
    eports!!! i get same error ssaying that :

    An error has occurred during report processing.
    Cannot create a connection to data source 'DT'.
    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    Thanks!!
  5. satya Moderator

    See whether that port is opened on network, as it might be closed if a firewall is installed within your network.

    See Mohammed's reference from BOL about this data connection error, if you try to run the report on the server locally, you should get more information about the error.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  6. PatDeV New Member

    I found the solution that i needed to have oracle client in order to make connection to datbase.

    thanks
    for the help.

    really great ful for that.

    Thanks!!
  7. satya Moderator

    Yes, thats the pain with having linked server to oracle.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page