problems with msde access from asp.net app
From: Ian (no_at_spam)
Date: 09/26/03
- Next message: greg: "After MS Critical updates, getting sa errors - HELP"
- Previous message: Rand Boyd [MS]: "RE: isql -E for SQL Server 7.0"
- Next in thread: Mary Chipman: "Re: problems with msde access from asp.net app"
- Reply: Mary Chipman: "Re: problems with msde access from asp.net app"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 26 Sep 2003 22:27:30 +0100
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: greg: "After MS Critical updates, getting sa errors - HELP"
- Previous message: Rand Boyd [MS]: "RE: isql -E for SQL Server 7.0"
- Next in thread: Mary Chipman: "Re: problems with msde access from asp.net app"
- Reply: Mary Chipman: "Re: problems with msde access from asp.net app"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
