Permissions required for synchronisation with SQL CLR

jamesdill

Hi

We are trying to perform a schema synchronisation, but unfortunately are getting a permission error when it appears to get to "Creating CLR Assemblies". (User does not have permission to perform this action).

We have give the user CREATE ASSEMBLY permission, but it doesn't seem to work. And yes, we do utilise CLR SQL.

Does anyone know what permission is required on the database (we are unable to give higher admin permissions).

Thanks
James

jamesdill

FYI - this was due to the usage of AUTHORIZATION to copy the assemblies over. The new DB didn't have permissions to change authorization to dbo. So we now need to come up with a way to allow that.