exception: could not impersonate the client during assembly file operation
When running the Create Assembly command in SQLServer for adding my CLR component to the database I got an exception similar to:
could not impersonate the client during assembly file operation
What it really was was a file-not-found error.
I was working on one machine but having the database on another. Since Create Assembly takes a file name/path as parameter it also has to find it. This means that the database process on the database machine is looking for the path; not the SQL tool.
The solution is to move the DLL to somewhere the database machine can reach it.