Wednesday, January 24, 2007

EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'.

I have hit a few problems after installing vista on to my laptop, the trickiest to fix was this one

EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'.

When running Visual studio 2005 and debugging a site this error pops up, this is the easiest fix ever, thanks to Chris' blog; http://professionalaspnet.com/blogs/aspnet_blog/archive/2006/03/14/sp-sdidebug.aspx, it saved the day.

Simply put you have to set the debugger to only check the native code, otherwise it 'guesses' which code to debug including SQL code, which it doesn't have access right to.

More on the vista install as it happens

goodluck

No comments: