Permissions to debug SQLCLR as non-admin

Does anyone now the minimum permissions to debug SQLCLR. I have a friend
trying to develop as a non-admin and he finds that it doesn't work even if
he launches Visual Studio to run as an admin account.
Is it possible? Are there certain rights required?
Simon SabinHi Simon,
Thank you for posting.
Regarding on the debugging SQL 2005 CLR objects in VS 2005, based on my
research, I haven't found any definite document said that non-admin user
can not perform such debugging. However, I did found the SQL CLR related
debugging require the symin permissino in SQLServer, built-in admin on
the machine automatically have this permission, so I think you can consider
granting the logon user the sys admin fixed role in SQL Server also. Also,
there're some other settings required before we perform SQL (TSQL or CLR)
debugging, here are the related MSDN document which mentioned this:
#SQL Debugging Limitations
http://msdn2.microsoft.com/en-us/library/kkyhd4yb(VS.80).aspx
#Debugging CLR Database Objects
http://msdn2.microsoft.com/zh-cn/library/ms131096.aspx
#How to: Enable CLR Debugging For a Connection
http://msdn2.microsoft.com/en-us/library/ms165039.aspx
In addition, for general throubleshooting, have you tried debugging normal
T-SQL to see whether it works? Or if we choose a local admin user to logon
, does it work. If logon with admin user works, we can confirm that the
problem is specific to a non-admin logon user case.
Hope this helps.
Regards,
Steven Cheng
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)