Re: Accessing data from remote SQL Server.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Scott Allen (bitmask_at_[nospam)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 10:47:15 -0400

Hi David:

By default the ASPNET account password is generated per machine, so
the ASPNET password on your local machine does not match the password
for the ASPNET account on the remote machine. You can explicitly set a
matching ASPNET password on both computers and it should work (don't
forget to set the ASPNET password in the processModel element of
machine.config too). 

--
Scott
http://www.OdeToCode.com
On Thu, 9 Sep 2004 23:45:02 -0700, DavidR
<DavidR@discussions.microsoft.com> wrote:
>Hi,
>
>My development machine is running Win XP SP2 and IIS. I'm developing an 
>ASP.NET application on this machine that accesses data from a SQL Server 
>database on another machine.
>
>That machine that contains the SQL Server runs Win 2003 and is the primary 
>controller for our domain.
>
>When I connect I receive the error "Login failed for user '(null)'. Reason: 
>Not associated with a trusted SQL Server connection."
>
>My connection string is ""integrated security=SSPI;data 
>source=SDI-SERVER01;persist security info=False;initial catalog=Contacts"
>
>In IIS, I have anonymous access checked and Integrated Windows Security set.
>
>In SQL Server, I have included the ASPNET account as a login, and also as a 
>user within the database I'm accessing.
>
>This problem seems to have been encountered plenty of times, and there are 
>quite a few solutions (eg impersonation, sql server authentication, etc), but 
>I'd like to find out why the error is occurring.
>
>Am I right in saying that the problem is happening because the local ASPNET 
>account credentials are being passed through and they are not seen as being 
>the same as the credentials for the ASPNET account on the server?
>
>If someone could help my understanding or point me in the direction of some 
>info, that would be great.
>
>Thanks,
>David.

Relevant Pages

  • Re: EXECUTE permission denied on object sp_sdidebug, database m
    ... It is just your local machine where you are having problems right? ... you need to install SQL Server before installing VS.Net and the .Net ... >> the aspnet account or your Windows login account to the SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Accessing data from remote SQL Server.
    ... > the ASPNET password on your local machine does not match the password ... > for the ASPNET account on the remote machine. ... >>ASP.NET application on this machine that accesses data from a SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • ASPNET account and NT Authentication with SQL Server -Account Locked Out
    ... Windows NT authentication. ... seems that windows is passing the ASPNET account to the SQL server box. ... So what I did was change the password of the ASPNET account. ... and store the password in the connection string. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Windows Domain Groups in Authorization section sans AD
    ... ASPNET account on my SQL server. ... Web apps connect to SQL with the SQL box's own local ASPNET ... I just tried deleting the domain ASPNET account I had created, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Authenticate Against localhost and AD
    ... authenticate users against local machine and Active Directory. ... By default, the application works as ASPNET account. ... currently I can authenticate users either in local system (when run as ...
    (microsoft.public.dotnet.security)