Ken
Sat May 08 08:22:38 CDT 2004
Hi,
Can you confirm the following assumptions that I'm making?
a) you are using Integrated authentication in SQL Server (based on the
trusted connection error)
b) you are running on Windows 2000 or Windows XP (based on the ASPNET
account reference)
c) you are running Framework v1.0 (based on ASPNET reference)
In SQL Server EM, can you go to:
-> Server name -> Security -> Logins
If <Machine>\ASPNET is listed, can you delete it, and then re-add it via EM?
If this does not solve the problem, can you run SQL Server Profiler, and
post a log here please? In the log, make sure that the ASPNET user is
attempting to connect to the correct database (just in case you have
different global.asax or similar between Web Matrix and your VS.NET project,
or whatever is uploaded to IIS).
Cheers
Ken
<anonymous@discussions.microsoft.com> wrote in message
news:a3a801c434fd$a51fa020$a301280a@phx.gbl...
: Kristofer,
:
: I can see what the error message says but by opening a
: page using the Web Matrix Server and not getting that
: error I have to think it's some setting in IIS.
:
: I'm familiar enough with SQL Server to have already
: set/re-checked that machine\ASPNET has permission to
: access every single select, insert, update, delete, and
: execute on every single table.
:
: I've gone so far as to have created a new db and .NET
: project from scratch. It's not just this one db; it's
: across the board access denial. Also, if I create a new
: user with all permissions granted and then use a username
: and pwd in the connection string (rather than
: trusted_connection) I get an error back saying
: [recentUser] doesn't have a trusted connection with the
: db.
:
: Which all leads me back to the beginning: Is there
: something in IIS I might check? The directory for this
: project is running as an application and the directory
: security has the default 'Anonymous access' and 'Allow
: IIS to control password' checked.
:
: thanks
:
: >-----Original Message-----
: >The error message tells you exactly what is wrong. The
: ASPNET user account
: >could not logon. Grant this user account permissions to
: logon, and it will
: >work.
: >
: >Why it works in WebMatrix? Well, it is not IIS, so it is
: possible that it
: >behaves different. Maybe it uses your username to logon
: to the database
: >server, and your username has permissions to logon?
: >
: >Are you sure you have given the ASPNET account
: permissions to logon to the
: >database server AND permissions to use the correct
: database AND permissions
: >to use any stored procedures you use AND access to
: tables AND ...?
: >
: >--
: >Regards,
: >Kristofer Gafvert - IIS MVP
: >
http://www.ilopia.com - When you need help!
: >
: >
: >"seth" <sethx9@yahoo.com> wrote in message
: >news:a24f01c434ae$a4640a30$a301280a@phx.gbl...
: >> I'm having the craziest problem.....Any .aspx page I
: make
: >> that I then run through IIS I get an error
: saying "Login
: >> failed for user 'machinename\ASPNET'" but if I run the
: >> exact same page through the WebMatrix server the page
: >> loads with the pulled data without a hitch.
: >>
: >> I've tried everything I can think of. It's NOT a
: problem
: >> with SQL Server (obviously) but I've made doubly sure
: of
: >> that by checking the user rights in Enterprise Manager.
: >>
: >> Please...if anyone can suggest something other than re-
: >> installing everything.....!!
: >
: >
: >.
: >
