Results 1 to 7 of 7
  1. #1
    Join Date
    Jun 2002
    Posts
    5

    Unanswered: xml template problem with sql server 20000

    I have tried to set up a virtual directory to one of the databases on my server through IIS Virtual Dir' Man' for sql server and although I can run any queries through the browser when I try to run an XML template it produces the following error :

    ERROR: 404 Not Found
    HResult: 0x80070005
    Source: Microsoft SQL isapi extension
    Description: Access denied

    I am stumped and wondered if anyone could help ?
    Thanks folks
    Jacqui

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Have you applied ss2k web release 1 hotfix ? If not, see the following:

    HOTFIX

  3. #3
    Join Date
    Jun 2002
    Posts
    5
    I have just installed it (incase) but it has made no difference to the error.

    Any other ideas ???

    Jacqui.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    In IIS what authentification method are you using - anonymous/basic/integrated ?

  5. #5
    Join Date
    Jun 2002
    Posts
    5
    Anonymous authentication

  6. #6
    Join Date
    Jun 2002
    Posts
    5

    Talking

    rnealejr

    You are great. You asking me about the authentication made me look at that deeper and I tried using Windows authentication and now it works quite hapily thanks a million.

    J

  7. #7
    Join Date
    Feb 2003
    Location
    Dubai
    Posts
    1

    SQLXML

    I am facing the same problem here. I am able to execute SQL queries in the URL but when i try to use a template which contains stored procedures with parameters an error message is coming which is

    ERROR: 404 Not Found
    HResult: 0x80070005
    Source: Microsoft SQL isapi extension
    Description: Access denied

    And the funny thing is that i am not getting this error and every thing works perfectly in my development server where as when i put the same thing in the production server its giving this problem.

    Only difference between the two is that i have Visual Studio .NET Architect and office 2000 in the development machine where as i dont have these in the production server. But i have installed the .NET Framework and the .NET SDK in the production server.

    Any body got any clue wats going wrong...I badly need a solution for this. Pls help

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •