Post reply

error 70 permission denied

  • September 12, 2007 at 10:05 am

    #176585

    Guys/Gals,

    My problem is this.... i have a db on sql server 2000 works fine, just created it in 2005 and it no longer works fine.

    The problem being... my asp page calls a storedprocedure and when it does it falls in a heap with the "error 70 permission denied" error.

    When i run this from the query analyser using exec MY_storedprocedure it works fine.

    What have i missed or what do i need to do to sort this out.

    Thanks in advance

    I.

  • September 13, 2007 at 12:01 am

    #733370

    Ian -

    Check the permissions on the stored procedure - does the login being use from asp have execute permissions on the stored procedure?

    Joe

     

  • September 13, 2007 at 5:08 am

    #733433

    Joe,

    Thanks for the advice, unfortunately i had already allowed execute permissions to the user on the stored procedure.

    But the plot does thicken, i have ran my application in the vb6 ide (its an iis.dll project) and it works, but still when i access the deployed app it comes back with permission denied.

    Any further ideas ?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply