I have downloaded a Data Access Component from Wrox which is featured in 
Chapter 11 of 'Professional VB.NET 2nd Edition'.  When I try to use it in 
my pages I get the following error:
"
Access to the registry key HKEY_CLASSES_ROOT\FPD.Data.ctrlSQLDAL is 
denied. 
Description: An unhandled exception occurred during the execution of the 
current web request. Please review the stack trace for more information 
about the error and where it originated in the code. 

Exception Details: System.UnauthorizedAccessException: Access to the 
registry key HKEY_CLASSES_ROOT\FPD.Data.ctrlSQLDAL is denied. 

The ASP.NET process is not authorized to access the requested resource. 
For security reasons the default ASP.NET process identity is '{machinename}
\ASPNET', which has limited privileges. Consider granting access rights to 
the resource to the ASP.NET process identity. 

To grant ASP.NET write access to a file, right-click the file in Explorer, 
choose "Properties" and select the Security tab. Click "Add" to add 
the "{machinename}\ASPNET" user. Highlight the ASP.NET account, and check 
the Write box in the Allow column.

Source Error: 

Line 44: 
Line 45:         'Try
Line 46:         objDAL = New ctrlSQLDAL()
Line 47:         objDAL.DBConnection = strConnection
Line 48: 
Source File: C:\Inetpub\wwwroot\fpd\cms\cma\ContentList.ascx.vb    Line: 
46 
"

I have used the sn tool to generate an .snk file and also registered 
FPD.Data.dll with regsvcs.  Both gave success messages.  I have tried 
changing the permissions for the APSNET user but I don't really know what 
I'm doing when it comes to Windows security.

I am running windows 2000 pro if that matters.  I have been pulling my 
hair out now for about two weeks over this one.

Can anyone out there help please.

Look under the help files in the IDE on security. 
There is a utility yu can call from a cmd prmpt witch will allow you to update 
the security settings.

- Kruse


-----Original Message-----
From: Andrew Hazell <andrew.hazell@a...>
To: ADO.NET <ado_dotnet@p...>
Sent: Wed Sep 18 17:40:45 2002
Subject: [ado_dotnet] Access to the registry key denied

I have downloaded a Data Access Component from Wrox which is featured in 
Chapter 11 of 'Professional VB.NET 2nd Edition'.  When I try to use it in 
my pages I get the following error:
"
Access to the registry key HKEY_CLASSES_ROOT\FPD.Data.ctrlSQLDAL is 
denied. 
Description: An unhandled exception occurred during the execution of the 
current web request. Please review the stack trace for more information 
about the error and where it originated in the code. 

Exception Details: System.UnauthorizedAccessException: Access to the 
registry key HKEY_CLASSES_ROOT\FPD.Data.ctrlSQLDAL is denied. 

The ASP.NET process is not authorized to access the requested resource. 
For security reasons the default ASP.NET process identity is '{machinename}
\ASPNET', which has limited privileges. Consider granting access rights to 
the resource to the ASP.NET process identity. 

To grant ASP.NET write access to a file, right-click the file in Explorer, 
choose "Properties" and select the Security tab. Click "Add" to add 
the "{machinename}\ASPNET" user. Highlight the ASP.NET account, and check 
the Write box in the Allow column.

Source Error: 

Line 44: 
Line 45:         'Try
Line 46:         objDAL = New ctrlSQLDAL()
Line 47:         objDAL.DBConnection = strConnection
Line 48: 
Source File: C:\Inetpub\wwwroot\fpd\cms\cma\ContentList.ascx.vb    Line: 
46 
"

I have used the sn tool to generate an .snk file and also registered 
FPD.Data.dll with regsvcs.  Both gave success messages.  I have tried 
changing the permissions for the APSNET user but I don't really know what 
I'm doing when it comes to Windows security.

I am running windows 2000 pro if that matters.  I have been pulling my 
hair out now for about two weeks over this one.

Can anyone out there help please.
---
ASP.NET Distributed Data Applications
This book will inspire you with a range of ideas on how data 
can be used to drive Web applications, and how that data can 
be most effectively utilized at each level of the design. 
Inefficient data use leads to the sort of slow, unresponsive 
Web applications that nobody enjoys using. By making good use 
of both server and client-side code, we can solve these 
problems. This book will arm you with the techniques you need 
to build Web applications that fly.
http://www.wrox.com/ACON11.asp?ISBN=1861004923

This message is for the named person's use only. It may contain 
sensitive and private proprietary or legally privileged information. 
No confidentiality or privilege is waived or lost by any mistransmission. 
If you are not the intended recipient, please immediately delete it and 
all copies of it from your system, destroy any hard copies of it and 
notify the sender. You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the 
intended recipient. CREDIT SUISSE GROUP and each legal entity in the 
CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business 
units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all 
e-mail communications through its networks. Any views expressed in this 
message are those of the individual sender, except where the message 
states otherwise and the sender is authorized to state them to be the 
views of any such entity.
Unless otherwise stated, any pricing information given in this message 
is indicative  only, is subject to change and does not constitute an 
offer to deal at any price quoted. Any reference to the terms of executed 
transactions should be treated as  preliminary only and subject to our 
formal written confirmation.

Thank you for the advice Kruse.  However the amount of information on 
security is massive and there are quite a few different tools available.  
I have already looked and tried many things including using the caspol 
exe. Nothing I have done so far has been successful. Security in dot net 
seems to be a bit of a minefield.

I have installed SP2 for the .net framework but that also made no 
difference.

Regards,

Andy.

> Look under the help files in the IDE on security. There is a utility yu 
can call from a cmd prmpt witch will allow you to update the security 
settings.

- Kruse


-----Original Message-----
From: Andrew Hazell <andrew.hazell@a...>
To: ADO.NET <ado_dotnet@p...>
Sent: Wed Sep 18 17:40:45 2002
Subject: [ado_dotnet] Access to the registry key denied

I have downloaded a Data Access Component from Wrox which is featured in 
Chapter 11 of 'Professional VB.NET 2nd Edition'.  When I try to use it in 
my pages I get the following error:
"
Access to the registry key HKEY_CLASSES_ROOT\FPD.Data.ctrlSQLDAL is 
denied. 
Description: An unhandled exception occurred during the execution of the 
current web request. Please review the stack trace for more information 
about the error and where it originated in the code. 

Exception Details: System.UnauthorizedAccessException: Access to the 
registry key HKEY_CLASSES_ROOT\FPD.Data.ctrlSQLDAL is denied. 

The ASP.NET process is not authorized to access the requested resource. 
For security reasons the default ASP.NET process identity is '{machinename}
\ASPNET', which has limited privileges. Consider granting access rights to 
the resource to the ASP.NET process identity. 

To grant ASP.NET write access to a file, right-click the file in Explorer, 
choose "Properties" and select the Security tab. Click "Add" to add 
the "{machinename}\ASPNET" user. Highlight the ASP.NET account, and check 
the Write box in the Allow column.

Source Error: 

Line 44: 
Line 45:         'Try
Line 46:         objDAL = New ctrlSQLDAL()
Line 47:         objDAL.DBConnection = strConnection
Line 48: 
Source File: C:\Inetpub\wwwroot\fpd\cms\cma\ContentList.ascx.vb    Line: 
46 
"

I have used the sn tool to generate an .snk file and also registered 
FPD.Data.dll with regsvcs.  Both gave success messages.  I have tried 
changing the permissions for the APSNET user but I don't really know what 
I'm doing when it comes to Windows security.

I am running windows 2000 pro if that matters.  I have been pulling my 
hair out now for about two weeks over this one.

Can anyone out there help please.
---
ASP.NET Distributed Data Applications
This book will inspire you with a range of ideas on how data 
can be used to drive Web applications, and how that data can 
be most effectively utilized at each level of the design. 
Inefficient data use leads to the sort of slow, unresponsive 
Web applications that nobody enjoys using. By making good use 
of both server and client-side code, we can solve these 
problems. This book will arm you with the techniques you need 
to build Web applications that fly.
http://www.wrox.com/ACON11.asp?ISBN=1861004923

This message is for the named person's use only. It may contain sensitive 
and private proprietary or legally privileged information. No 
confidentiality or privilege is waived or lost by any mistransmission. If 
you are not the intended recipient, please immediately delete it and all 
copies of it from your system, destroy any hard copies of it and notify 
the sender. You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the 
intended recipient. CREDIT SUISSE GROUP and each legal entity in the 
CREDIT SUISSE FIRST BOSTON or CREDIT SUISSE ASSET MANAGEMENT business 
units of CREDIT SUISSE FIRST BOSTON reserve the right to monitor all e-
mail communications through its networks. Any views expressed in this 
message are those of the individual sender, except where the message 
states otherwise and the sender is authorized to state them to be the 
views of any such entity.
Unless otherwise stated, any pricing information given in this message is 
indicative  only, is subject to change and does not constitute an offer to 
deal at any price quoted. Any reference to the terms of executed 
transactions should be treated as  preliminary only and subject to our 
formal written confirmation.