Post reply

Cannot create connection to data source

  • August 11, 2005 at 8:29 am

    #165583

    Hi All,

    I am trying to create a few reports using Reporting Services - I can create the report and preview it but when I try to run it on the server, I get the following error message

    An error has occurred during report processing. (rsProcessingAborted) Get Online Help

    Cannot create a connection to data source 'DataSource'. (rsErrorOpeningConnection) Get Online Help

    Login failed for user 'user'.

    The user account is fine - any ideas what could be happening. Thanks so much!!

  • August 11, 2005 at 9:51 am

    #581454

    You may just run thru and double check the attributes for the report.

    Click the report, then click the properties tab. Then click the data sources link on the left. Make sure there is a data source defined for your report. The data source is not embedded in the rdl file, it is set server side. Even though you specified one in visual studio when creating the report it does not persist when you deploy, or upload to the server.

     

     

     

  • August 11, 2005 at 11:22 pm

    #581654

    Hi,

    You could verify the data source settings in the Reporting Server page itself.

    Check the connection string and connection credentials in the Properties page of this data source.

     

    Warm Regards,

    Preeti Tamhankar

  • August 13, 2005 at 11:45 pm

    #582057

    U shoul check in:

    Project->properties->Deployment->OverwriteDataSources

    if it's false so any change u do doesn't deploy on the server.

Viewing 4 posts - 1 through 3 (of 3 total)

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