Re: ASP.net Integrated Security SQL Server

From: Larry Hastings (greg.@remove-me.unixsucks.com)
Date: 11/24/02 

From: "Larry Hastings" <greg.@remove-me.unixsucks.com>
Date: Sat, 23 Nov 2002 23:09:41 -0600

It fails becouse by default wp_net.exe is running under local ASPNET account which does not have access to any network resources.
There are several ways to solve the problem:
1. Use SQL authentication (in connection string)
2. Create same account for ASPNET on both machines
3. Change your wp_net.exe account to run under local system account and then use integrated security. You'd get authenticated as
DOMAINNAME\Machine$ (my favourite solution)

Greg

"Jerry Sherman" <jerry_sherman@nospam.tvratings.com> wrote in message news:fac901c2867f$b8c063e0$3bef2ecf@TKMSFTNGXA10...
> ERROR: Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection.
>
> (intranet application)
>
> Application has been working fine using Integrated
> Authentication up until I separated the SQL Server that
> its using from the IIS Server.
>
> Same User has rights on the test sql server as the
> production however, i get the above error message when
> trying to hit that sql server.
>
> any suggestions? I thought it might have something to do
> with the ASPNET user...but shouldn't the sql server still
> use the NT authentication from the user that is logged in?
>
> TIA,
> Jerry
>

Relevant Pages
Loading