Re: Cannot access databases
From: Mary Chipman (mchip_at_online.microsoft.com)
Date: 08/21/04
- Next message: Martin: "windows reauthorisation checkpoints?"
- Previous message: Jos: "Re: ValidateRequest="false" ?"
- In reply to: Goreyman: "Cannot access databases"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sat, 21 Aug 2004 10:27:13 -0400
When running an ASP.NET, it's not your administrative rights that are
considered, but the rights granted to the ASPNET worker process that
count. So you need to grant the ASPNET windows account login
permissions in SQL Server, and read/write ACLs on the share that
contains the Access mdb. This is explained in detail in the ASP.NET
security best practices wp, which you can download from
http://www.microsoft.com/downloads/release.asp?ReleaseID=44047
--Mary
On Fri, 20 Aug 2004 08:47:04 -0700, "Goreyman"
<Goreyman@discussions.microsoft.com> wrote:
>I cannot get past ASP.NET security.
>
>I am running W2K Pro with IIS5 on a standalone deskktop. I log on with full
>administrative rights. I created a VB.NET project with one form containing a
>datagrid control and attempted to execute a simple SQL query against an
>unprotected copy of Biblio.mdb (Access 2000) using Oledb objects. Web page
>loaded blank, Refresh brought up an error page with message that attempt to
>login username failed.
>
>I then tried running a query against Northwind on Sql Server using SqlClient
>objects. Page does not load - I get a message box stating "Error while trying
>to run the project: Unable to start debugging on the web server. You do not
>have permissions to debug the server. Verify that you are a member of the
>'Debugger Users' group on this server". Event viewer shows the error
>"aspnet_wp.exe could not be launched because the username and/or password
>supplied in the processModel section of the config file are invalid". When I
>reverted to the Access version, page no longer loads - I now get the message
>box error.
>
>In trying to solve the problem I ran into other issues which may or may not
>be related. When I try to add a user to a group, MMC.EXE generates this
>messsage "The instruction at "0x6992375e" referenced memory at "0x00000000".
>The memory could not be "read". All memory diagnostics pass and I swapped out
>all memory modules but still get message. Tried to reinstall IIS from disk
>but nothing happens. (Incidentally, when I look at group members I get just
>icons with no descriptive text - is this normal?)
>
>I am completely stumped at this stage. Have looked at various forums,
>refernece books etc but am getting nowhere.
>
>Any help would be greatly appreciated.
>
>
>
- Next message: Martin: "windows reauthorisation checkpoints?"
- Previous message: Jos: "Re: ValidateRequest="false" ?"
- In reply to: Goreyman: "Cannot access databases"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
