Windows Authentication, strange problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rebeuapaname@hotmail.com - 27 Jan 2006 08:12 GMT

Hi,

I have a strange problem i will expose the situation :

- All the user able to view reports are impersonificated to "USERX" on
my ASP.Net Application
- I have added rights for "USERX" on the report server
- I have added rights for "USERX" on ReportServers databases and on the
DataSource DATABASES

BUT...it doesnt work !

The user can connect to the report, but it generate this error

"Login fail for user login (null)"

Why the login user is it "NULL" and not "USERX", I have traced SQL
Queries and the user used is "USERX"

I'am really desapointed ?

Someone have an idea ?

THANKS

Reply to this Message

Teo Lachev [MVP] - 30 Jan 2006 22:11 GMT

That's because you are running into a typical double (if not tripple if your
app and Report Server are on different machines) hop. NTLM doesn't support
cross-machine impersonation. Instead, you have to use either Kerberos
delegation or standard authentication. See "Connecting to Remote Data
Sources" topic in the product documentation.

Signature

HTH,
----------------------------------------------
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/

-------------------------------------------------

> Hi,
>
[quoted text clipped - 20 lines]
>
> THANKS

Reply to this Message