Monday, February 20, 2012

Problems using Reporting Services.

Hi, we are using reporting services 2000. Everything works fine with
integrated security (windows user). But we change all the reports that
didnt use it.
At this moment, the integrated security (windows user) doesnt 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.codecomments.com ***
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/is...ecurityBriefs/
"MariaGuzman" <marisa@.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
> didnt use it.
> At this moment, the integrated security (windows user) doesnt 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.codecomments.com ***

No comments:

Post a Comment