I am currently in the process of transferring databases and reports to a new clustered SQL server. The issue I am running in to is for reports accessing data on a different SQL server I am receiving the error message below. This is happening when trying to view the reports in Report Manager, but runs fine when previewing the report in VS2008.
Cannot create a connection to data source 'DS_NAME'.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I have tried about every combination I can think of as far as security options in the data source definition. The preferred option is to have everything using integrated security because we manage everything by AD groups.
Just hoping someone out there may have an idea of what else I need to look at. Any assistance would be greatly appreciated!