Re: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server

From: michelle (michelle_at_nospam.com)
Date: 12/23/04 

Date: Thu, 23 Dec 2004 11:11:09 -0600

The times that I have seen this have been caused by the local security
policy - local policies|user rights assigment|access this computer from the
network.

"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

Relevant Pages

  • Re: IIS Security Problems
    ... reason why if auditing of logon events is enabled in Local Security Policy ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Group Policy Defaults
    ... between an import of security policy out of a template as compared ... the Local Group Policy Object for security settings was ... The settings displayed in the Local Security Settings snapin now ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Local Security Policy resets
    ... auditing of process tracking and policy change for success. ... security log to see if an event is recorded that shows that the user right ... I have an issue where the Local Security Policy\Local Policies\User Rights ... If I choose to Analyze Computer Now in Security Configuration and Analysis ...
    (microsoft.public.windowsxp.security_admin)
  • What is this "Security Templates" error message ?
    ... "Security Templates" ... "The Group Policy security settings that apply to this machine could not be ... All local security settings will be displayed, ...
    (microsoft.public.windowsxp.security_admin)
  • RE: SQL Slammer doing the rounds again?
    ... SQL Slammer doing the rounds again? ... "I used to hate writing assignments, ... > Security Business Unit ... > at the largest, most highly-anticipated industry ...
    (Incidents)
Loading