Post reply

execute permission was denied on the object xp_instance_regread

  • May 19, 2011 at 8:38 am

    #239970

    hi,

    i am getting the below error when I right click on table

    Error 229, execute permission was denied on the object xp_instance_regread database msssqlsystemresource schema sys

    I dont want to give the execute permission to xp_instance_regread

    if any one help me to out of this problem

    thanks

  • July 17, 2011 at 4:59 pm

    #1354014

    I am curious to see if anyone has found a viable solution to this problem yet.

    I have the same issue when using Management Studio 2008 R2 against SQL Server 2000 databases and later. While one can click pass the error, it is not a solution our developers are wanting to use indefinitely; and I dont' blame them. Until this is remedied in a future Cumulative Update or Service Pack, is there any way around this without granting EXECUTE on the extended procedure to PUBLIC?

    It doesn't look like SP1 for 2008 R2 is going to address this issue as of the time I am writing this. I have seen elsewhere the possibility of suppressing the error (Microsoft Connect). Has anyone had any luck with that? Any other ideas?

    -Siggy.

  • July 17, 2011 at 6:37 pm

    #1354019

    You are going to have to GRANT EXEC Permissions to the User Account that you are Executing the Stored Procedure from.

    http://sqlblog.com/forums/thread/12431.aspx

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

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

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