Integrated Authentication not working for remote datasources.

Hi,

I'm having problems getting integrated authentication to work when a datasource points to a database on a remote server.

Here's an example of what I'm using for a connection string:

Data Source=<server>;Initial Catalog=<database>

When I try to run a report w/ Integrated Authentication checked, I get the following error:

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'VistaGlobal'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors.

The following is logged on the remote server where the datasource points to:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I can't figure one why it's logging in anonymously when I'm running the report from Report manager. It works when I explicitly supply my user login but doesn't work w/ integrated authentication. Also, the report will run fine if I point the datasource to a database on the report server. Any help is appreciated.

Thanks,

Henry

Figured it out... I have to enable IIS to use Kerberos authentication.

Here's the KB article that I followed: 326089