Unsafe Assembly Permissions

[Brady Kelly]

We're struggling to register an unsafe assembly on a development server.
The message given is:



CREATE ASSEMBLY for assembly 'Pastel.Evolution' failed because assembly
'Pastel.Evolution' is not authorized for PERMISSION_SET



Now I remember running a grant, "USE Master GRANT EXTERNAL ACCESS ASSEMBLY
TO [SERVERNAME\User]" on my server, but the target server doesn't use
windows auth, and you can't grant rights to 'sa'. Any ideas on how we can
allow ourselves to register an unsafe assmemly?


===================================
This list is hosted by DevelopMentor� http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

[Peter Ritchie]

A naive Google search found these:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=359264&SiteID=1
http://www.sqljunkies.com/WebLog/ktegels/archive/2006/08/14/safetydancelite
.aspx

Do they help?

===================================
This list is hosted by DevelopMentor® http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com