Re: problems with msde access from asp.net app
From: Mary Chipman (mchip_at_nomail.please)
Date: 09/28/03
- Next message: Louis Davidson: "Re: Look at this important pack"
- Previous message: Arun: "Re: Grant permissions"
- In reply to: Ian: "problems with msde access from asp.net app"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 28 Sep 2003 14:49:53 -0400
How the ASPNET account is configured is controlled by the
machine.config file on each machine in the processModel section. Your
default choices are to set the username to either system (not
recommended) or machine. You can also elect to run under a custom user
account for which you supply a username and password in machine.config
(can be encrypted in v1.1). The error message you got is telling you
that you are running under the system account on the production box,
and most likely are running under machine on your test server.
Grab the ASP.NET security best practices whitepaper, which explains
all this and more in great detail.
http://www.microsoft.com/downloads/release.asp?ReleaseID=44047
-- Mary
MCW Technologies
http://www.mcwtech.com
On Fri, 26 Sep 2003 22:27:30 +0100, "Ian" <no@spam> wrote:
>hi
>
>i have a problem with database access (SQL Server/MSDE) on my production
>server.
>
>the asp.net web app works fine in test.
>
>on the production server, it won't connect to the database!
>
>i'm pretty sure i have set up the ASPNET login correctly, with permissions
>identical to my test system
>
>it only fails when trying to use a Trusted connection for ASPNET - using an
>SQL connection.for use 'sa' works just fine.
>
>the only clue i have is a SQL security log entry of "login failed for 'NT
>AUTHORITY\NETWORK SERVICE'"
>
>if i add a login for 'NT AUTHORITY\NETWORK SERVICE' and the NamedPipes
>protocol, i can connect OK. This is good, but i'd love to know why ASPNET
>won't connect!
>
>Thanks
>Ian
>
>
- Next message: Louis Davidson: "Re: Look at this important pack"
- Previous message: Arun: "Re: Grant permissions"
- In reply to: Ian: "problems with msde access from asp.net app"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
