Post reply

Permissions

  • June 24, 2008 at 4:48 pm

    #99161

    I am EXEC a store proc on server A which in turn

    EXEC another proc from another server B.

    I have admin rights on both servers but still gives me an error when EXEC inner Porc.

    This is the Error.

    Msg 229, Level 14, State 5, Procedure Report1, Line 50

    The EXECUTE permission was denied on the object 'Report2', database 'EMP', schema 'dbo'.

  • June 25, 2008 at 7:32 am

    #833934

    Check the security context for the linked server? It may not have execute rights on remote server.

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

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