RE: Authenticating between Webserver and database Server

From: Alejandro Mesa (AlejandroMesa_at_discussions.microsoft.com)
Date: 06/24/05


Date: Fri, 24 Jun 2005 06:50:02 -0700

See "Security Account Delegation" in BOL.

AMB

"PublicRick" wrote:

> Not sure if this is an ASP.NET or a SQL issue...
>
> Environment:
> Webserver on Server1
> SqlServer on Server 2
>
> Both machines in the same domain. I have followed the steps in the to create
> a domain level account to run the ASPNET process that has access to the
> database.
>
> When I try to retrieve data from the DB, i get:
> Login failed for user '(null)'. Reason: Not associated with a trusted SQL
> Server connection. 18452
>
> Any guidence would be appriciated.
>
>



Relevant Pages

  • Re: linked server security problem?
    ... Security Account Delegation. ... describes the issue/error you are receiving: ... PRB: Message 18456 from a Distributed Query ... >linked Server A to Server B using [Be made using the login's current ...
    (microsoft.public.sqlserver.security)
  • Re: Remote Indexing Server - authentication problems
    ... Query Analyzer on the DB server (using a domain account) works fine. ... I feel it has something to do with security account delegation, ... set to run SQL Server service? ...
    (microsoft.public.sqlserver.fulltext)
  • Authenticating between Webserver and database Server
    ... Not sure if this is an ASP.NET or a SQL issue... ... SqlServer on Server 2 ... Both machines in the same domain. ... Server connection. ...
    (microsoft.public.sqlserver.security)
  • Re: Remote Indexing Server - authentication problems
    ... This should be on your remote Index Services server. ... Looking for a SQL Server replication book? ... Query Analyzer on the DB server (using a domain account) works fine. ... I feel it has something to do with security account delegation, ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Linked Server Security
    ... Check out "Security Account Delegation" in the BOL. ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.security)