Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Reporting Services - NT AUTHORITY\ANONYMOUS LOGON

Author  Topic 

sqldba20
Posting Yak Master

183 Posts

Posted - 2013-12-04 : 13:18:52
Folks:

We have a report which runs fine if in our data souce we select 'Credentials stored securely in the report server' and set a windows account. Our requirement is to use 'Windows Integrated Security' so the report runs using the logged in users credentials. For some reason when I select the 'Windows Integrated Security' option the report runs under 'NT AUTHORITY\ANONYMOUS LOGON' account. Is there any setting I need to set on the server or domain so that the report will run using the logged in users credentials?

Our environment:
We have Reporting Services 2008 R2 on SERVER A and the Report Server Databases on SERVER B. The reporting services service is running using a domain admin account.



Thanks !

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-12-05 : 02:31:15
see if this helps

http://www.windows-tech.info/15/60d4107d45305888.php

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

sqldba20
Posting Yak Master

183 Posts

Posted - 2013-12-05 : 16:45:58
This helped:

http://sql-ution.com/kerberos-delegation-with-reporting-services/

or

http://blogs.technet.com/b/rob/archive/2011/11/23/enabling-kerberos-authentication-for-reporting-services.aspx



Go to Top of Page
   

- Advertisement -