Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
simondeutsch
Aged Yak Warrior
547 Posts |
 Posted - 2010-04-14 : 15:28:01
|
| The assembly is not safe and CREATE ASSEMBLY MyAssemblyFROM 'C:\MyPath\MyAssembly.dll'WITH PERMISSION_SET = UNSAFEGOkeeps on failing even though I am logged on as sa and the database is set to TRUSTWORTHY = ON.The error message says that it order for an unsafe assembly to register, the DBO must have UNSAFE ASSEMBLY permissions (which should be implicit to the sa account) and the database must be set to TRUSTWORTHY. Both of these conditions are true yet the assembly still won't register. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2010-04-14 : 21:48:08
|
| Thanks! sp_changedbowner did the trick. This database had been backed up on one server and restored to another, which was where the problem was happening. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Cannot CREATE ASSEMBLY