I'm trying to link 2 SQL Servers (2008 and 2005). I have tried it via the GUI and scripts, and having no luck. I have problems trying to to query through it with access. As I'm not the Admin of the network, I'm working hard on investigating how to success on this but I always receive a message telling me that the user "../Anonymous Logon" is not allowed to connect.
After some research, I believe this is a problem related to Kerberos that is not transferring my credentials to the machine I'm trying to link to. I'm using NT Authentication and I have no possibility to use/create SQL Authentication logins.
I've already sent a mail to my network Admin to see if we are able to use Kerberos delegation here.
What would be the next steps to find out what is happening to my configs and why this isn't working?
Thanks in advance and, as this is my first question, hello everybody!