Thursday, March 29, 2012

distributed install - connection error

we have a sql server 2005 reporting services distributed installation

db server has: sqldb01\dev, sqldb01\tst, sqldb01\beta

web server is TestWeb01. This had dev, tst, beta installations of report server

all reports are working ok except on beta. Beta was setup just a couple days ago so it has not worked thus far.

all reports use a shared data source on beta(just like on dev and tst)

here is the error on beta for all the reports:

any idea? (SQLDB01_DEV is not the shared data source name. SQLDB01_DEV was used by the developer when creating the report. But this should not matter right? The report should ignore this and use the shared data source i assume?)

  • An error has occurred during report processing.

  • Cannot create a connection to data source 'SQLDB01_DEV'.

  • For more information about this error navigate to the report server on the local server machine, or enable remote errors

  • It is the problem. You need to go the report properties page after deployment to confirm that it's looking at the shared datasource.|||

    yes. after deployment from TST to BETA(using the rdl file), i went into each report and set it to use shared datasource i created there on BETA.

    so it should use the shared datasource. It does that ok on DEV & TST (well the reports run fine on DEV & TST anyway)

    so why is BETA giving that error? If it used the shared datasource then it should ignore the SQLDB01_DEV data source that the developer created when desiging the report...right?

    |||

    is this by any chance also the name of the source database?

    what is your shared data source on beta pointing to?

    have you tested this connection using another means? e.g. management studio.

    |||

    developer created datasource name is SQLDB01_DEV

    shared datasource name is resload.mms

    all looks ok from Report Manager and Management Studio

    except the reports gives that error.

    sql
  • No comments:

    Post a Comment