Problems with debugging remotely SQLCLR stored procedures?

Hello,

my username is se\levalencia, I had before the database on my machine, but as now we have a server I backed up the database and restored on the server, it seems that it has the sames logins and security users,

Its strange because the user dbo is assigned the user se\levalencia on the server, and I cant alter the user dbo.

The user dbo should be the login sa? I am in big trouble with this, beacuase I cant debug my sql clr stored procedure.

T-Sql execution ended without debugging. You may have not have sufficient permissions to debug.

I am using a connection with windows authentication, so it means that its sending tha tokes as se\levalencia to the server.

Please feel free to ask for more information about it. Thanks

More strange yet, I just changed the connection and put SA as the user which executes the sql clr stored procedure, I got the same problem, its supposed to be a super user.

|||

You would need to add se\levalencia as a member of sysadmin role on the server. For debugging T-SQL as well as SQLCLR the debugger needs to run under an account that is a member of sysadmin role on SQL Server.

Thanks,

-Vineet.