SQL Server Performance

Cannot get to script the shared data source to link with reports

Discussion in 'SQL Server Reporting Services' started by Yap Wen Qin, Apr 14, 2008.

  1. Yap Wen Qin New Member

    Hi, all,
    I am using the RSScripter to script the shared data source to link with reports. But I keep on trying and trying to link the data source with reports, but still cannot. Anyone got good solutions to help me?
    When I click the report that I script in Report Server, will display this message:
    • The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)
    So anyone can give me some idea to solve this problems.
    Thank you
  2. satya Moderator

    Welcome to the forum!
    Check the relevant RDL is setup properly, such as data source property.
    If you are using a browser other then IE or you are not connected to the network you will be prompted for your login credentials. This is to initially access the Report Manager site. Once in there if your data sources are set to use Windows Credentials I do not believe they will be able to connect if you are logged in remotely.

Share This Page