Re: Assembly could not be installed because existing policy would keep it from being used

MS
What if you change to
with permission_set = SAFE ?







"MS" <adriandams@xxxxxxxxx> wrote in message
news:O5h%23Pa1wJHA.988@xxxxxxxxxxxxxxxxxxxxxxx
This is the query I am using (yes, clr is enabled. the only query below
that fails is the last one)

sp_configure 'clr enabled', 1
go
reconfigure
go
exec sp_dbcmptlevel 'IncuityStore', 90
go
alter database IncuityStore set trustworthy on
go
Create assembly [MyAssembly]
from 'C:\svndev\Services\MyAssembly.dll'
with permission_set = unsafe


"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:eeK9wP1wJHA.1212@xxxxxxxxxxxxxxxxxxxxxxx
MS
Can you post the exact command, btw, have you enabled CLR on the server ?




"MS" <adriandams@xxxxxxxxx> wrote in message
news:un15fM1wJHA.5672@xxxxxxxxxxxxxxxxxxxxxxx
I have an application that loads a dotnet assembly into sqlserver and it
works fine on my dev machine, but fails with the following error on the
customers machine.

Assembly 'MyAssembly' could not be installed because existing policy
would keep it from being used

I have looked into the enterprise, machine and user code access policies
and they all seem to allow execution. At any rate, I don't see any
difference between the policies on the target machine and those on my
dev machine, but I guess I'm not looking in the right place.

Does anyone know what policy is being referred to in this error?







.

Relevant Pages

  • Re: Assembly could not be installed because existing policy would keep it from being used
    ... works fine on my dev machine, but fails with the following error on the ... Assembly 'MyAssembly' could not be installed because existing policy would ... I have looked into the enterprise, machine and user code access policies ...
    (microsoft.public.sqlserver.security)
  • Assembly could not be installed because existing policy would keep it from being used
    ... works fine on my dev machine, but fails with the following error on the ... Assembly 'MyAssembly' could not be installed because existing policy would ... I have looked into the enterprise, machine and user code access policies and ...
    (microsoft.public.sqlserver.security)
  • Re: Nurburgring.
    ... It's a public one way toll road with no speed limit, so unless specifically excluded by your policy, or you are breaching the "racing / competition" rules on the policy, then going for a nice gentle sunday drive around the ring cannot be reason for invalidating the policy any more than going for a nice gentle sunday drive around the coventry inner ring road. ... And remember kids, RAID is safe and the UPS never fails, and Cisco routers never develop intermittent faults, and external hard drives never fail with only a month's use, and the DNS is reliable and resilient, and the mailserver is protected from all forms of attack, and the replacement UPS will be reliable as the first one was an unusual failure. ...
    (uk.rec.cars.modifications)
  • Re: Problem accessing a file on a remote machine from a Service app. XP.
    ... It probably fails on XP because by default there is a policy that restricts ... the Everyone group such that for network access it only covers authenticated ... of the "Network accesses always authenticate as guest" policy, ...
    (microsoft.public.platformsdk.security)
  • [SLE] Re: Using OT to indicate off-topic or not? -- Policy Debate
    ... You can argue policy back and forth until the list is sick. ... Meta-discussions tend to be self-perpetuating and tangent ... But when all else fails, Golden Rule is the best individual policy. ...
    (SuSE)
Quantcast