Getting error in registering the SQLCLR procedure...

hi, Derek Comingore

My self Jitendra Nayi....

I am trying to generate a SQL CLR stored procedure and i have done it too. Now the next step is to convert that *.dll file in to assembly. I am getting erro that. My server Database is on the LAN, not on my PC.

Here is the code which i have tried to register an assembly...

/*

CREATE ASSEMBLY MyAssembly FROM 'C:\Documents and Settings\Administrator.ORC80\My Documents\Visual Studio 2005\Projects\MyDB1\MyDB1\bin\Debug\MyDB1.dll'

WITH PERMISSION_SET=SAFE

GO

*/

and here is the error that i am getting...

/*

Msg 6585, Level 16, State 1, Line 1

Could not impersonate the client during assembly file operation.

*/

Please help me .I am stuck at here.

Are you running as a Windows login or SQL login? Only Windows logins can read assemblies in create assembly.|||In addition to what Mark B says in his reply; your CREATE ASSEMBLY statement references an absolute path to the assembly. Does the server box have access to this path and is the path visible to the server box?

Niels