SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Could not impersonate the client...
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tfountain
Constraint Violating Yak Guru

USA
491 Posts

Posted - 06/03/2009 :  12:52:11  Show Profile  Reply with Quote
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

USA
491 Posts

Posted - 06/19/2009 :  13:50:23  Show Profile  Reply with Quote
No one has any ideas?
Go to Top of Page

Nightness
Starting Member

1 Posts

Posted - 08/12/2012 :  14:13:21  Show Profile  Reply with Quote
Prefix "EXECUTE AS USER='dbo';" to that when using SQL Authentication.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000