SSRS 2005 Connecting to data on 2000

Hot Topic

Error encountered while installing SQL Server Express Edition
Converting from 2005 to 2000
SQLExpress database file auto-creation error
Registry to store configuration values ?
INCORRECT DATA WHEN USING MOLAP AND HOLAP STORAGE.
Converting a Hex String to a Varbinary or vice versa
dataset parameters eliminated
How to use resultset as a source for UPDATE SQL
Sharing DataSource or DataSourceView
Sql Server Begin Transaccion-Commit Transaccion problem

SQL Server

SQL Server Management Studio Express CTP
SQL Mail
Performance with multiple packages in the IDE
Page or File Restore - Warning Message
exporting reports into EXCEL format
Error from DataSet reading information from SSIS
how to solve Syntax error or access violation?
OLEDB source - Use table or select only columns needed.
error creating a new pull subscription
ForEach Loop utilisation

SSRS 2005 Connecting to data on 2000

Hello,

I 'm building the reports on SSRS 2005 and connection to a 2000 DB, every thing seems to go ok, except when i try to see the reports on the web browser. At that point i got the following error.

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

I know that is not advised to do this connection but what can i do to solve this problem

I Also tryied to force windows and a typed credentials but without sucess.

  • Can anyone help me Thank you. Nuno




    • Answer this question

    SSRS 2005 Connecting to data on 2000

    • celticJedi

      For the equivalent to the previous post, but the connection to a relational DB a got this

      • An error has occurred during report processing. (rsProcessingAborted)
        • Cannot create a connection to data source 'BI_IVN_RELACIONAL'. (rsErrorOpeningConnection)
          • Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

      I use windows credentials , why do i get this

      Do i have tu use a https connection



    • Anton de Gruchy

      Ok, now i know how to enable it and the error that i got is

      • An error has occurred during report processing. (rsProcessingAborted)
        • Cannot create a connection to data source 'BI_IVN'. (rsErrorOpeningConnection)
          • A connection cannot be made. Ensure that the server is running.
            • No connection could be made because the target machine actively refused it

      I can't undesrtand this, because it works with proclarity and everything else, including with report services when im building the reports.

      only when i want to see the deployed reports i got that message.

      Thank you for your help



    • Nate of T

      Are your RS server and data sources on different machines The error most likely has something to do with double-hop issue. If so you can try:

      1) use stored credientials for you data sources.

      2) Install RS and SQL on the same machine.

      3) Implement kerberos http://support.microsoft.com/ id=319723

    • pdesai

      I have tryied another thing that was to change the connection to a oledb connection using the msolap provider all the 3 versions that i think i know.

      the result is i get everthing empty.

      But if i try using the SSIS, or debug the reports i can acess the data like i would like, what are the differences between these connections and the connections that IE, trough reporting services generated html/aspx, does

      PS: I cannot try that Kerberos thing for now, sorry.

      Thank you



    • kofighanaba

      Hi,

      Sorry to say but the first two will not be enough, because i would like to use the windows credentials to validate the user.

      And the Analisys server DB is already on a different machine, so i think that having 2 different versions of sql server on the same machine is not likely to be installed.

      I will try the point 3.

      Thank you



    • RussHolmes

      I don't know how to enable remote errors.



    • Mentalor

      What do you see when you enable remote errors
    • SSRS 2005 Connecting to data on 2000
    Answer this question