"Bob Albert" <anonymous@discussions.microsoft.com> wrote in message
news:027701c4e74c$75efb130$a601280a@phx.gbl...
> Have an APP running IIS on one box and SQL on a Win 2K3.
> When running through a browser located on a completely
> different box (double hop) the credentials get lost (as
> designed by MS) and user is only known as Anonymous.
> Everything is fine and expected so far. SQL on Win 2K
> allowed such users to pass and access the db, Win 2K3
> does not. I know there are alternatives ranging from
> using SQL Authentication to setting Kerberos (and the
> like), but these aren't options for me. I am looking for
> someone who knows which W2K3 security policy, registry
> setting, or, User group needs to be set/changed so that
> W2K3 will give anonymous users access to SQL.
>
> Running SQL Profiler with Security Audit Event logging
> for Loggin failiures does show the failed attempt by
> IIS. The following message is delivered to the browser:
>
> Unable to open database connection. (0x80004005: Login
> failed for user '(null)'. Reason: Not associated with a
> trusted SQL Server connection.),
> Provider=SQLOLEDB.1;Server=QMS3;Database=MessageStats;Trus
> ted_Connection=Yes;Current Language=English;Locale
> Identifier=1033
>
> (0x80040114)
>
>
> Any help would greatly be appreciated.
>
> Bob