I am trying to build a CLR function which will return a list of remote sessions on various servers. I'm using an external .Net Library of functions called Cassia which i've been recommended by a friend.
I am using impersonation within the function and this works fine when the function is hosted on my local machine and is executed from my local machine. However, if i connect to my local machine from a remote server and execute the function, i get "Access
is denied" errors. My feeling is that this has something to do with delegation but i'm at a bit of a loss as to how to troubleshoot or progress this issue.
Can anyone point me in the direction of a possible solution- i can post the source code if required.
I'm running SQL2008 Sp1 on Windows XP SP3. The remote servers are all Win2k3.
every day is a school day
View Complete Post