Linked Server error

  • Hi I'm trying to render a SSRS report which is giving me the following error.The report involves in rendering data from 3 different linked servers. The report renders fine in the visual studio where I build the report. (I build the report from different server and just called the store proc remotely. Everything works fine here.)

    Error: "An error has occurred during report processing. (rsProcessingAborted)

    Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)

    Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. OLE DB provider "SQLNCLI10" for linked server "DataServerSeven" returned message "Invalid connection string attribute."

    Please help me to solve this linked server error.

  • "Invalid connection string attribute."

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply