Linked Server Authentication Help - Login Failed

Hi there.
I've been trying to get linked servers set up on two servers. Here is what i
have done in my test environment.

I've got two servers. Test1 and Test2. They are Standard 2005 installs.
I've got two user accounts set as local admin on both servers They run the
SQL service and are called Test1_SA and Test2_SA.
I've added Domain\MyUser on to both master databases for access.

Test1 server and Test1_SA user account are the ones i need to configure for
delegation yes?

I've then done this to setspn(because they don't get added?):

SETSPN -A MSSQLSrv/TEST:1433 DOMAIN\TEST1_SA
SETSPN -A MSSQLSrv/TEST.DOMAIN.COM:1433 DOMAIN\TEST1_SA
SETSPN -A MSSQLSrv/TEST1:1433 DOMAIN\TEST2_SA
SETSPN -A MSSQLSrv/TEST1.DOMAIN.COM:1433 DOMAIN\TEST2_SA

I've then logged on to Test1 server and added Test1_SA to the 'impersonate'
local policy setting.
I've rebootd everything.


Now when i run this to check if everything is ok on the first server first
of all i get NTLM back which is wrong. I should be getting Kerberos?
select auth_scheme from sys.dm_exec_connections
NTLM is returned.

If i try and run a linked query i get this. Well first i run this command:

sp_addlinkedserver Test2

Then i test with this command:

select name from Test2.master.sys.servers where server_id = 0

I then get the response:


Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

I really can't work out what i am doing wrong? Any help appreciated.


Thanks.



.

Relevant Pages

  • Linked Server Autentication - Help - Login Failed
    ... I've been trying to get linked servers set up on two servers. ... have done in my test environment. ... Test1 and Test2. ...
    (microsoft.public.sqlserver.setup)
  • Re: Replication problems
    ... Always test ANY suggestion in a test environment before implementing! ... I get the following error when trying to manually replicate between to 2 ... xxx.com from doamin controller xxx to domain controller xxx ... Both DC's are Windows 2003 R2 servers and nothing has been done lately to ...
    (microsoft.public.windows.server.active_directory)
  • Re: Setting a test environment for SBS 2003 R2. Questions regarding router configurations.
    ... OK let me just add that currently my test environment is setup without the ... Gateway: 11.22.3.45 ... DNS: 192.168.100.2 ... 192.16.100.2 (DNS is forwarded to ISP's DNS servers) ...
    (microsoft.public.windows.server.sbs)
  • Setting a test environment for SBS 2003 R2. Questions regarding router configurations.
    ... I'm setting up a test environment for SBS 2003 R2 Premium to be used as SBS ... DNS: 192.16.100.2 (DNS is forwarded to ISP's DNS servers) ...
    (microsoft.public.windows.server.sbs)
  • Re: Strange WAN Communication Problem
    ... I've seen this in my test environment on one machine, ... While at the branch I found I could ping ... > the router and XP workstations at the main office, but not these servers. ...
    (microsoft.public.windows.server.general)