Hello there. I am executing the statement:CREATE ASSEMBLY <insert assembly name here>FROM 'C:\PathLocalToDatabase\myCLR.dll'WITH PERMISSION_SET = SAFE;
When I do this, I receive the following error:Msg 6585, Level 16, State 1, Line 14Could not impersonate the client during assembly file operation.
I have verified the following to be true:- The DLL does exist
- It is in a location local to the database server and not the user
I know the issue revolves around file system permissions. I have the following questions- 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?