Problem:
'Could not impersonate the client during assembly file operation' error message when publishing a stored procedure in Enterprise Developer.
Solution:
SQL Server has two layers – there are logins which connect you to a SQL Server instance (authentication) – and then these logins are mapped to SQL Server userids which are granted permissions at the database level.
To resolve the error, do the following for SQLCLR SPs (grant sysadm role to logins):
- From SQL Server Management Studio, Object Explorer – click Security, then Logins
- Click on the login you want to change – then select Server Roles and check 'sysadm'.
- Click on the login you want to change – then select Server Roles and check 'sysadm'.
This article may be helpful as well:
#EnterpriseDeveloper
#MFDS
