Could not impersonate the client...

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

.NET Inside SQL Server (2005)

Could not impersonate the client...

Author

Topic

tfountain
Constraint Violating Yak Guru

491 Posts

Posted - 2009-06-03 : 12:52:11

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 14
Could 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?

tfountain
Constraint Violating Yak Guru

491 Posts

Posted - 2009-06-19 : 13:50:23

No one has any ideas?

Nightness
Starting Member

1 Post

Posted - 2012-08-12 : 14:13:21

Prefix "EXECUTE AS USER='dbo';" to that when using SQL Authentication.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources