Welcome to HostingForumz.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

data access iis7/vista

 
   Web Hosting Problem Solving Community! (Home) -> IIS RSS
Author Message
hugh welford

External


Since: Aug 27, 2007
Posts: 3



(Msg. 1) Posted: Mon Aug 27, 2007 2:01 pm
Post subject: data access iis7/vista
Archived from groups: microsoft>public>inetserver>iis (more info?)

Hi

Have just installed IIS7 on Vista and am trying to access a .mdb file
through ASP. Getting "An error occurred on the server when processing the
URL".

I think the problem is in the file permission. Under XP Pro/IIS6 is used to
have to set the .mdb file security via windows explorer to give
IUSR_machinename full permissions on this file for anonymous web access.

Cant seem to do this with Vista explorer - says object cannot be found.

Also, getting conflicting statements from IIS Help - it tells me firstly
that

a. By default, IIS 7.0 uses IUSR as the account for anonymous access.
This account is created when you install IIS 7.0.

and then

b. Similarly, a new Windows built-in account named IUSRS replaces the
local IUSR_MachineName anonymous account from IIS 6.0.

Anyway, whatever syntax I use, I cant seem to add anonymous web user
permission to daters.mdb via the security tab in Windown Explorer.

Any help greatly appreciated - getting very frustrated

Thanks

Hugh

 >> Stay informed about: data access iis7/vista 
Back to top
Login to vote
hugh welford

External


Since: Aug 27, 2007
Posts: 3



(Msg. 2) Posted: Tue Aug 28, 2007 3:56 am
Post subject: Re: data access iis7/vista [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thanks for the feedback, guys

Input from various people has resulted in me assuring that the following
have full
control permissions for IUSR and IIS_IUSRS accounts - this may or may not be
over the top, but it has solved the problem

a. The .mdb file to be accessed
b. C:\Windows\Temp
c. C:\Windows\ServiceProfiles\NetworkService\AppData\Local\Temp

Hope this is useful

Regards

Hugh



"hugh welford" <hugh.welford.DeleteThis@btinternet.com> wrote in message
news:uoPk1hM6HHA.1188@TK2MSFTNGP04.phx.gbl...
> Hi
>
> Have just installed IIS7 on Vista and am trying to access a .mdb file
> through ASP. Getting "An error occurred on the server when processing the
> URL".
>
> I think the problem is in the file permission. Under XP Pro/IIS6 is used
> to
> have to set the .mdb file security via windows explorer to give
> IUSR_machinename full permissions on this file for anonymous web access.
>
> Cant seem to do this with Vista explorer - says object cannot be found.
>
> Also, getting conflicting statements from IIS Help - it tells me firstly
> that
>
> a. By default, IIS 7.0 uses IUSR as the account for anonymous access.
> This account is created when you install IIS 7.0.
>
> and then
>
> b. Similarly, a new Windows built-in account named IUSRS replaces the
> local IUSR_MachineName anonymous account from IIS 6.0.
>
> Anyway, whatever syntax I use, I cant seem to add anonymous web user
> permission to daters.mdb via the security tab in Windown Explorer.
>
> Any help greatly appreciated - getting very frustrated
>
> Thanks
>
> Hugh
>

 >> Stay informed about: data access iis7/vista 
Back to top
Login to vote
Bernard Cheah [MVP]

External


Since: May 31, 2005
Posts: 346



(Msg. 3) Posted: Tue Aug 28, 2007 2:03 pm
Post subject: Re: data access iis7/vista [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

a) configure asp to send detail error msgs, and disable IE friendly error
msgs.
%windir%\system32\inetsrv\appcmd.exe set config -section:asp
/scriptErrorSentToBrowser:true

b) look at this kb
Error message when you request an ASP page that connects to an Access
database in IIS 7.0: "Microsoft JET Database Engine error '80004005'"
http://support.microsoft.com/Default.aspx?id=926939

--
Regards,
Bernard Cheah
http://www.iis.net/
http://msmvps.com/blogs/bernard/


"hugh welford" <hugh.welford RemoveThis @btinternet.com> wrote in message
news:uoPk1hM6HHA.1188@TK2MSFTNGP04.phx.gbl...
> Hi
>
> Have just installed IIS7 on Vista and am trying to access a .mdb file
> through ASP. Getting "An error occurred on the server when processing the
> URL".
>
> I think the problem is in the file permission. Under XP Pro/IIS6 is used
> to
> have to set the .mdb file security via windows explorer to give
> IUSR_machinename full permissions on this file for anonymous web access.
>
> Cant seem to do this with Vista explorer - says object cannot be found.
>
> Also, getting conflicting statements from IIS Help - it tells me firstly
> that
>
> a. By default, IIS 7.0 uses IUSR as the account for anonymous access.
> This account is created when you install IIS 7.0.
>
> and then
>
> b. Similarly, a new Windows built-in account named IUSRS replaces the
> local IUSR_MachineName anonymous account from IIS 6.0.
>
> Anyway, whatever syntax I use, I cant seem to add anonymous web user
> permission to daters.mdb via the security tab in Windown Explorer.
>
> Any help greatly appreciated - getting very frustrated
>
> Thanks
>
> Hugh
>
 >> Stay informed about: data access iis7/vista 
Back to top
Login to vote
kenremove

External


Since: Aug 23, 2003
Posts: 3041



(Msg. 4) Posted: Tue Aug 28, 2007 2:15 pm
Post subject: Re: data access iis7/vista [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi,

Before assuming that this is a permissions issue, can you post the HTTP
status and substatus codes?

Also, have you installed the custom errors module? If you do so, and access
the site as http://localhost or http://127.0.0.1 you should get a very
detailed error message indicating what the problem is. Can you post that
erro rmessage please?

Cheers
Ken

"hugh welford" <hugh.welford.DeleteThis@btinternet.com> wrote in message
news:uoPk1hM6HHA.1188@TK2MSFTNGP04.phx.gbl...
> Hi
>
> Have just installed IIS7 on Vista and am trying to access a .mdb file
> through ASP. Getting "An error occurred on the server when processing the
> URL".
>
> I think the problem is in the file permission. Under XP Pro/IIS6 is used
> to
> have to set the .mdb file security via windows explorer to give
> IUSR_machinename full permissions on this file for anonymous web access.
>
> Cant seem to do this with Vista explorer - says object cannot be found.
>
> Also, getting conflicting statements from IIS Help - it tells me firstly
> that
>
> a. By default, IIS 7.0 uses IUSR as the account for anonymous access.
> This account is created when you install IIS 7.0.
>
> and then
>
> b. Similarly, a new Windows built-in account named IUSRS replaces the
> local IUSR_MachineName anonymous account from IIS 6.0.
>
> Anyway, whatever syntax I use, I cant seem to add anonymous web user
> permission to daters.mdb via the security tab in Windown Explorer.
>
> Any help greatly appreciated - getting very frustrated
>
> Thanks
>
> Hugh
>
 >> Stay informed about: data access iis7/vista 
Back to top
Login to vote
Display posts from previous:   
   Web Hosting Problem Solving Community! (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]