create assembly from network location

Posted by mjw06d on Server Fault See other posts from Server Fault or by mjw06d
Published on 2011-04-05T17:09:48Z Indexed on 2014/05/30 3:32 UTC
Read the original article Hit count: 352

Filed under:
|
|

The error I'm receiving:

CREATE ASSEMBLY failed because it could not open the physical file "\\<server>\<folder>\<assembly>.dll": 5(Access is denied.).

TSQL:

exec sp_configure 'clr enabled', 1
reconfigure
go
create assembly <assemblyname> from '\\<server>\<folder>\<assembly>.dll'
with permission_set = safe

How can I create an assembly from a unc path?

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about unc