Problems using Reporting Services.

21 Feb 2006 6:44 PM

MariaGuzman

Hi, we are using reporting services 2000. Everything works fine with
integrated security (windows user). But we change all the reports that
didn´t use it.

At this moment, the integrated security (windows user) doesn´t work.
Reports this error:
Login failed for user 'NT AUTHORITY/ANONYMOUS LOGON'

We already check that the user has access on the reporting services
folder and the database.

do you have any clue that can help us to determine the problem???

Thanks a lot for your help..

*** Sent via Developersdex http://www.developersdex.com ***

23 Feb 2006 4:23 PM

Joe L

This is a delegation issue. If SRS is installed on the separate server from
your data source, the SRS server needs to impersonate your SQL Account for
authentication to the database server.

There is a good writeup on implementing and troubleshooting delegations at:
http://msdn.microsoft.com/msdnmag/issues/05/09/SecurityBriefs/

Show quote

"MariaGuzman" <mar***@devdex.com> wrote in message
news:%23Q3FobxNGHA.420@tk2msftngp13.phx.gbl...
> Hi, we are using reporting services 2000. Everything works fine with
> integrated security (windows user). But we change all the reports that
> didn´t use it.
>
> At this moment, the integrated security (windows user) doesn´t work.
> Reports this error:
> Login failed for user 'NT AUTHORITY/ANONYMOUS LOGON'
>
> We already check that the user has access on the reporting services
> folder and the database.
>
> do you have any clue that can help us to determine the problem???
>
> Thanks a lot for your help..
>
>
> *** Sent via Developersdex http://www.developersdex.com ***