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

[Bill Thames]

I am learning the debugger using IBuySpy. I make small changes to the code
and use the debugger to see the effects of my changes. WindowsXP crashed and
now when I try to debug IBuySpy, I get the following errors while the
programs is starting, and these errors have nothing to do with the areas I
have changed. IBuySpy wirks flawslessly if I run it without debugging. I
would appear that the problem lies in the debugger itself. Can anyone help?

Thanks,
Bill

[SqlException: EXECUTE permission denied on object 'sp_sdidebug', database
'master', owner 'dbo'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
System.Data.SqlClient.SqlConnection.IssueSQLDebug(UInt32 option, String
machineName, UInt32 pid, UInt32 id, String sdiDllName, Byte[] data)
System.Data.SqlClient.SqlConnection.CheckSQLDebug(SqlDebugContext sdc)
System.Data.SqlClient.SqlConnection.CheckSQLDebugOnConnect()
System.Data.SqlClient.SqlConnection.OpenWithDebugger()
System.Data.SqlClient.SqlConnection.Open()

ASPNET.StarterKit.Commerce.ASPNET.StarterKit.Commerce.ProductsDB.GetProductC
ategories() in K:\ASP.NET Starter
Kits\aaaa\CommerceVBVS\Components\ProductsDB.vb:65
ASPNET.StarterKit.Commerce.C_Menu.Page_Load(Object sender, EventArgs e)
in K:\ASP.NET Starter Kits\aaaa\CommerceVBVS\_Menu.ascx.vb:44
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()

[Bill Thames]

Here is some additional information:

A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

I hope this helps,

Bill

"Bill Thames" <bt...@eritter.net> wrote in message news:uZ1za2K...@TK2MSFTNGP10.phx.gbl...

[Bill Thames]

Did I forget to take a bath or something??? Must be some reason for being
ignored. Perhaps there are no Gurus out there. Oh well! I tried!

"Bill Thames" <bt...@eritter.net> wrote in message
news:uZ1za2K...@TK2MSFTNGP10.phx.gbl...

[[MVP] SmileSeo]

Hi. Bill.

As your message explained, sp_sdidebug has no EXECUTE permission. You can
set database permission in the database management tool. Did you do it
already?

--

--------------------
Microsoft .NET MVP

"Bill Thames" <bt...@eritter.net> wrote in message
news:uZ1za2K...@TK2MSFTNGP10.phx.gbl...

[Richard Cook [MSFT]]

Hello,

Here is whats happening:

When you try to debug your application the TSQL debug engine is trying to
attach. According to the error message, you do not have permission to debug
TSQL code on the server. So a failure occurs.

But when you just RUN the app, it will work because none of the debug
engines are attempting to attach.

Here is how to resolove your problem:

First of all try [MVP]SmileSeo's suggestion and setup the permissions for
TSQL debugging, if that is what you are trying to do. Also if you are
running SQL2K SP3 then you will also need to run the following TSQL code
once

exec sp_sdidebug 'legacy_on'

Or if you do not want to debug TSQL code, simply go to the Project
Properties->Debug->Enable SQL Debugging and uncheck it.

Hope this helps.

Regards

Richard

"Bill Thames" <bt...@eritter.net> wrote in message

news:uqJpir0b...@TK2MSFTNGP11.phx.gbl...

[Bill Thames]

I sure do appreciate all the response to my problem. Thanks to all.

Now then, I am using MSDE and can't find any kind of database management
tools. I can't even find reasonable documentation. How do I manage the
server without installing the full (expensive) SQL-2000?

"Richard Cook [MSFT]" <rich...@online.microsoft.com> wrote in message
news:u4uO3Omc...@TK2MSFTNGP10.phx.gbl...