RE: [OT] Problems with Win2003 IIS6 ASP Classic

["Alex Monaghan" <ha@xxxxxxxxxxxxxx>]

I'd run IIS under an account with the necessary permissions to access
your
database.

I was on a project a few years ago using ASP on a W2K3 SP2 box and there
were some big permissions issues. We had a box with a clean install which
was much tighter security than the IIS5 box that had been upgraded to IIS6.

Our Dev box worked fine as it started life as a W2K server, then got
upgraded over the years, the production box was a clean install.

-----Original Message-----
From: ukha_d@xxxxxxx [mailto:ukha_d@xxxxxxx] On Behalf Of
ukha@xxxxxxx
Sent: 10 September 2007 11:35
To: ukha_d@xxxxxxx
Subject: [ukha_d] [OT] Problems with Win2003 IIS6 ASP Classic

Hi All,

Can anyone help with a Win2003 problem.


I have an ASP application (Classic ASP not ASP.net) that works fine on
XP PRo IIS5 but I just cant get it to run under Win2003 IIS6. As soon
as I try to create a database connection I get the following
error.......


Server object error 'ASP 0178 : 80070005'

Server.CreateObject Access Error

/crm/Includes/AppConn.asp, line 9

The call to Server.CreateObject failed while checking permissions.
Access is denied to this object.



..... the offending line is .....

Set connection = Server.CreateObject("ADODB.Connection")


I have googled extensively and tried all the different settings that
are suggested in the various sites and have gone so far as to give
full access to IUSR_<machinename> and EVERYONE but I still dont get
permission to create the ADODB object.

ASP is definately working because the first page I hit is
"index.asp"
which then redirects to "Welcome.asp" because I am not logged in.
I
complete the login and submit but everything then comes to a halt as I
cant create the database connection.

Hopefully there is a Win2K3 guru out there who can tell me exactly
where I am going wrong !!!

Thanks

Keith