Reporting services - Data Sources

• sqldba20

  Ten Centuries

  Points: 1308

  More actions

  December 4, 2013 at 11:12 am

  #285649

  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 !

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  December 4, 2013 at 9:28 pm

  #1670907

  For this to work, you will need to get Kerberos authentication configured. Have a look at http://blogs.technet.com/b/rob/archive/2011/11/23/enabling-kerberos-authentication-for-reporting-services.aspx - it has (I think) sufficient information to get you going.

  If you want more info, try googling "SSRS Kerberos" or "ssrs double hop"