SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


OS or other permissions in order to install assemblies?


OS or other permissions in order to install assemblies?

Author
Message
Dave Poole
Dave Poole
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26532 Visits: 3541
I've been trying to install a SAFE assembly which is supplied as a block of hexadecimal bytes.

I know categorically that it is safe and it installs absolutely fine under local instances of SQL Server, both 2005 & 2008.

On our shared servers I get the dreaded 6218 error. The only thing I can think of is that these servers us a domain account for the MSSQLSERVER service and that this account does not have suitable permissions to access the .NET framework. The service account is NOT a local administrator.

Does anyone know of any specific permissions that are necessary to register assemblies?

I've heard the term "blessed" assemblies but I'm not sure if this is the same thing as the GAC. Do I need specific permissions to reference these assemblies?

LinkedIn Profile
www.simple-talk.com
Orlando Colamatteo
Orlando Colamatteo
SSC Guru
SSC Guru (77K reputation)SSC Guru (77K reputation)SSC Guru (77K reputation)SSC Guru (77K reputation)SSC Guru (77K reputation)SSC Guru (77K reputation)SSC Guru (77K reputation)SSC Guru (77K reputation)

Group: General Forum Members
Points: 77776 Visits: 14499
Which version of the FW are you targeting? Check your SQLCLR assembly's references to make sure those exist on the server.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Dave Poole
Dave Poole
One Orange Chip
One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)One Orange Chip (26K reputation)

Group: General Forum Members
Points: 26532 Visits: 3541
I'm trying to install SQLSharp on a SQL2005 server patched up to build 5000.

I can do it provided I mark all the assemblies as UNSAFE.

Installing on a SQL2008 server presents no problems with the assemblies in the default install of SAFE.

The SQL Server service account is in the local admins group. Probably shouldn't be, but that's another story! Anyway my initial thought was that it was some form of permissions issue but I'm clutching at straws.

LinkedIn Profile
www.simple-talk.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search