Jump to Report Error after SP1

I have a textbox on a report that has the advanced navigation jump to report
property set to another report three properties are passed to the "jump to
report". There is one dataset on the original report that is using a report
datasource with a specific username and password that allows the saving of
the password.
This works correctly when executing the report in visual studio design time.
It doesn't work correctly after it is deployed and it gets executed from the
report server/manager web site. When the user clicks the text box that
executes the "jump to" report the following error comes up:
The current action cannot be completed because the user data source
credentials that are required to execute this report are not stored in the
report server database. (rsInvalidDataSourceCredentialSetting)
This worked fine before SP1 was installed.
Any assistance would be appreciated.
Tim
tfogel@.idmi.comOne of the changes in SP1 was require the unattended execution account to be
specified on the server when running reports with datasources with
CredentialsOptions = None.
If you are using a data source that requires no credentials, for ex. Access
or XML files, set the unattended account using rsconfig -u ...
If you are using a data source that requires credentials, for ex: SQL,
Oracle, DB/2, etc. store credentials in the report server.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tim Fogel" <tfogel@.idmi.com> wrote in message
news:OCEdA9dXEHA.1144@.TK2MSFTNGP12.phx.gbl...
> I have a textbox on a report that has the advanced navigation jump to
report
> property set to another report three properties are passed to the "jump to
> report". There is one dataset on the original report that is using a
report
> datasource with a specific username and password that allows the saving of
> the password.
> This works correctly when executing the report in visual studio design
time.
> It doesn't work correctly after it is deployed and it gets executed from
the
> report server/manager web site. When the user clicks the text box that
> executes the "jump to" report the following error comes up:
> The current action cannot be completed because the user data source
> credentials that are required to execute this report are not stored in the
> report server database. (rsInvalidDataSourceCredentialSetting)
> This worked fine before SP1 was installed.
> Any assistance would be appreciated.
> Tim
> tfogel@.idmi.com
>