Hello there. I am executing the statement:
CREATE ASSEMBLY <insert assembly name here>
WITH PERMISSION_SET = SAFE;When I do this, I receive the following error:
Msg 6585, Level 16, State 1, Line 14
Could not impersonate the client during assembly file operation.I have verified the following to be true:
I know the issue revolves around file system permissions. I have the following questions
- The DLL does exist
- It is in a location local to the database server and not the user
- When logged into SQL Server as a SQL Server login, what account is used to access the file system? Is it the NT AUTHORITY/SYSTEM account or the account SQL Server is configured to run as?
- What is the best practice for deploying CLR components to the database?