Security on Created Virtual websites IIS

[JScannell]

I have IIS on my desktop (XP Professional IIS version 5) and wish to add a new virtual website off the default website. I do that but when I try to connect to my Access DB I get the now famous "The Microsoft Jet database engine cannot open the file 'c:\inetpub\

http://wwwroot\sitename\database\dbname.mdb'.

It is already opened exclusively by another user, or you need permission to view its data."

I have tried everything I can think of as far as permissions, directory security, and nothing works.

There has to be a definitive list of steps that I must follow for this and any site I try to create.

Please help...

Thanks, Jerry Scannell

Jerry Scannell

 

[JohnYingling]

Have you given NTFS access to that folder to NETWORK SERVICE, the ID that ASPX runs under

http://www.moldyoldy.com/VBComparedemo

- free online Compare/Diff of snippets

 

[JScannell]

John,

I haven't done that. Unfortunately I don't know what that is nor do I know how to do it. The site is utilizing classic ASP so do I still have to worry about it? I have other sites on that same IIS that don't have the problem.

What I have done is to look at the "security and sharing" settings of the folders in Windows Explorer, as well as check the security settings in IIS.

I made sure that IUSR-xxxxx identities have full access to the website. But there are so many potential users that I don't know which ones to use. there's "Everyone", "Administrators", etc.

My problem is, and I have had to deal with this forever, is that I am not a network guy. I'm a developer. Consequently, when it comes to setting up IIS, I don't know really what to do. I have tried leaving defaults where ever they are and then changing stuff until it eventually works.

What I truly need is a foolproof checklist of what has to be done in order to setup IIS, create a "virtual directory" to an internal site that runs classic ASP and interfaces with MS Access (or in some situations SQL Server) via ODBC or OLE DB. Where the security settings have to be set and what values/properties are.

Thanks,
Jerry

Jerry Scannell

 

[etjohnson81]

Do you have it open in Access? If you are editing the database, you can't connect to it.

Like previously mentioned, your ASP service account, or network service account need modify access to the folder holding the database.