Reports broke from remote

Hello
Recently this one report errors as below when running on any machine except
the actual server hosting the
reporting services.
a.. An error has occurred during report processing.
a.. Cannot create a connection to data source 'databasename.
a.. For more information about this error navigate to the report
server on the local server machine, or enable remote errors
They did recently change the name of the machine hosting the datasource, but
it shows up OK
in RS config manager.
Anything else I could look at?
Regards
CTCheck out the credentials for the report datasource. I always use shared
datasources but perhaps this report uses a report specific datasource that
has a problem.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MSNewsGroup" <Cal@.obded.org> wrote in message
news:eYZ0uws0HHA.3848@.TK2MSFTNGP03.phx.gbl...
> Hello
> Recently this one report errors as below when running on any machine
> except the actual server hosting the
> reporting services.
> a.. An error has occurred during report processing.
> a.. Cannot create a connection to data source 'databasename.
> a.. For more information about this error navigate to the report
> server on the local server machine, or enable remote errors
> They did recently change the name of the machine hosting the datasource,
> but it shows up OK
> in RS config manager.
> Anything else I could look at?
> Regards
> CT
>|||Could that be if it works on the machine hosting RS?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e3Ywj7s0HHA.464@.TK2MSFTNGP02.phx.gbl...
> Check out the credentials for the report datasource. I always use shared
> datasources but perhaps this report uses a report specific datasource that
> has a problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "MSNewsGroup" <Cal@.obded.org> wrote in message
> news:eYZ0uws0HHA.3848@.TK2MSFTNGP03.phx.gbl...
>> Hello
>> Recently this one report errors as below when running on any machine
>> except the actual server hosting the
>> reporting services.
>> a.. An error has occurred during report processing.
>> a.. Cannot create a connection to data source 'databasename.
>> a.. For more information about this error navigate to the report
>> server on the local server machine, or enable remote errors
>> They did recently change the name of the machine hosting the datasource,
>> but it shows up OK
>> in RS config manager.
>> Anything else I could look at?
>> Regards
>> CT
>|||It depends on how the credentials are configured. Check and see if it is
using a shared datasource or report datasource. If report datasource compare
how its credentials are setup compared to a report datasource/shared
datasource that works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MSNewsGroup" <Cal@.obded.org> wrote in message
news:%23ag1lpt0HHA.4824@.TK2MSFTNGP02.phx.gbl...
> Could that be if it works on the machine hosting RS?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:e3Ywj7s0HHA.464@.TK2MSFTNGP02.phx.gbl...
>> Check out the credentials for the report datasource. I always use shared
>> datasources but perhaps this report uses a report specific datasource
>> that has a problem.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "MSNewsGroup" <Cal@.obded.org> wrote in message
>> news:eYZ0uws0HHA.3848@.TK2MSFTNGP03.phx.gbl...
>> Hello
>> Recently this one report errors as below when running on any machine
>> except the actual server hosting the
>> reporting services.
>> a.. An error has occurred during report processing.
>> a.. Cannot create a connection to data source 'databasename.
>> a.. For more information about this error navigate to the report
>> server on the local server machine, or enable remote errors
>> They did recently change the name of the machine hosting the datasource,
>> but it shows up OK
>> in RS config manager.
>> Anything else I could look at?
>> Regards
>> CT
>>
>