access denied to data source reporting services 2000

I have data on server A and the report server on server B.

I have created reports that I can run through report manager (on server B).

I have depolyed the reports but when I try to run the reports on client computers I get the following error:

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Cannot create a connection to data source 'ABCD'. (rsErrorOpeningConnection) Get Online Help

SQL Server does not exist or access denied.

I have tried setting different credentials ... windows security, specified username and password to credentials not required ...

All give above error.

TIA

You will have to provide more information in order to help you. Are the servers on different domains ? Are you able to open the report while being logged on to server B locally ? Aren′t you able to access the report from ServerB while logged on at clientA. Are you using the same account for logging on ? How is IIS setup on the server ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Both servers are on the same domain. The reports work from server b logged on as administrator locally.

I have configured the reports to be able to be accessed by a domain group. The group has Browser and My Reports roles assigned.

The users are logged on as themselves.

IIS is setup to have windows integrated authentication.

I have setup the report to have a sql server username and password for the datasource stored on the report server.

Hope that helps.

|||if you setup the data source for SQL Server authentication, this should work both from ServerB and ClientA. If you are using Windows authentication you will have to use the setspn command in order to enabled the security delegation for the server. Otherwise the server cannot check the credentials of the user.

HTH, jens K. Suessmeyer.

http://www.sqlserver2005.de