Hello everybody,
we have the following scenario: sql reporting services on server A and MOM reporting services DB as well as MOM Database on server B.
When we now try to connect to MOM reporting using the URL the reporting services site properly appears and we can click on 'MOM reporting' however if we want to open any report like i.e. 'MOM health summary' we always get the following output:
'Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection'
We assume it has someting to do with the settings in the DataSource 'SCDW' - however - everything we tried in the SCDW-settings failed.
Could you please help us ? That would be great !
Thanks very much.
Cheers,
prolin
we have the following scenario: sql reporting services on server A and MOM reporting services DB as well as MOM Database on server B.
When we now try to connect to MOM reporting using the URL the reporting services site properly appears and we can click on 'MOM reporting' however if we want to open any report like i.e. 'MOM health summary' we always get the following output:
'Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection'
We assume it has someting to do with the settings in the DataSource 'SCDW' - however - everything we tried in the SCDW-settings failed.
Could you please help us ? That would be great !
Thanks very much.
Cheers,
prolin