Authenticating between Webserver and database Server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PublicRick - 24 Jun 2005 14:44 GMT

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.

Reply to this Message

Alejandro Mesa - 24 Jun 2005 14:50 GMT

See "Security Account Delegation" in BOL.

AMB

> Not sure if this is an ASP.NET or a SQL issue...
>
[quoted text clipped - 11 lines]
>
> Any guidence would be appriciated.

Reply to this Message

Jens Süßmeyer - 24 Jun 2005 15:06 GMT

http://msdn.microsoft.com/library/default.asp?
AND
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/secmod/html/sec
mod19.asp

HTH, Jens SUessmeyer.

> Not sure if this is an ASP.NET or a SQL issue...
>
[quoted text clipped - 12 lines]
>
> Any guidence would be appriciated.

Reply to this Message