SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Reporting Services - NT AUTHORITY\ANONYMOUS LOGON
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sqldba20
Posting Yak Master

183 Posts

Posted - 12/04/2013 :  13:18:52  Show Profile  Reply with Quote
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 !

Edited by - sqldba20 on 12/04/2013 16:05:13

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 12/05/2013 :  02:31:15  Show Profile  Reply with Quote
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 - 12/05/2013 :  16:45:58  Show Profile  Reply with Quote
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




Edited by - sqldba20 on 12/05/2013 16:49:05
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000