IIS Problem please Help!!

[damaster]

hi,

I have just updated my Windowx XP Machine with the latest Patches & Security Fixes provided by Microsoft. be4 things were goin fine but now after I Installed all of that, my IIS or some thing else has a Problem I get this Message:

##############################################
Error Type:
Microsoft JET Database Engine (0x80004005)
Unspecified error
/forum_2/common.asp, line 250
##############################################

I cant access the Database on my local Server. The problem seems 2 be as if its not allowing the ASP script 2 write on the DB in using Access DB.

please Help me out if u can. [xx(]
Thanx

__________________________________________________ __________________
__________________________________________________ __________________

Previously my problem was solved my addin the IUSR account in the Admin group, but i have checked & the IUSR account has Admin Group rights I also added it to guests group. & Also restartd the IIS several timez But its not connecting 2 the any of the Database again! the ASP pages are workin fine!

any suggestions plzzzzzzzzzzzz

Regards,
>Da^Master<

[Rob]

Firstly.... it is a BAD security risk adding the iusr_computername account to admin group because then you are unleashing all permissions to an anonymous user (BAD IDEA!).

Remove it from admin group.

Next, right click on your iis root, and select 'security'. Give read, write permissions to iusr_computername.

Problem solved.... although from your error message, it doesn't look like a database permissions error.

[damaster]

errrr... can u tell me the steps 2 that? cuz I couldnt find that Security oh btw im using windows XP Pro.

[Rob]

ok....

Open up folder options on any folder (tools, folder options)

On the view tab, untick 'use simple file sharing' (last option)

You will then get the security tab when you right click wwwroot and select properties.

[damaster]

well... I got that done.

I gave full control to the IUSR_XXX for wwwroot folder
Also I keep all the databases in the wwroot\admin\database folder
I have also given Full premission to IUSR_XXX on this folder as well.

but its still the same!

U know I tired to connect with Snits Forums as well. which i had running previously on my machine as well

* it gave me the following Error!

************************************************** ****************************************
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.

Code : 80004005

Error Description :
[Microsoft][ODBC Microsoft Access Driver] Disk or network error.
************************************************** ****************************************

any other suggestion?

[Smokie]

Try compact and repair on the database. Make sure there are no strange permissions set on the database itself.

[damaster]

well i dont think its a database problem cuz i have like more than 20 ASP applications using different databases in the same folder. but all are returning the same error message. from which it is sure that there is a problem in reading or writing to the database!

[damaster]

thanx fellas the problem is solved now.. it was a security issue for the IUSR_XXX i changed the password for that user & its workin fine now..

[AJ]

Thanks for your email, Da^Master. I had already done all the security stuff prior to my post - should've mentioned that.

I finally fixed this by setting the ConnectionTimeout property of the connection object to 20:

SET oConn = Server.CreateObject("ADODB.Connection")
oConn.ConnectionTimeout = 20

Thanks for your help.

How did changing the password help? Where did you change the password?

(I have the same problem...)

[Webforumz Staff]

If the IUSR_xxx accounts do not have good read/write/execute access to your www folder and database folders, then they cannot perform some actions and you get these sort of problems.