ScottStonehouse
2008-09-03 15:55:02 UTC
I'm trying to setup a linked server. The issue I am having is this error:
"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server,
Error: 18456)"
Server A is SQL 2005 windows logins only Server B is the same (SQL 2005
windows logins only)
Server A runs windows XP Server B runs Windows Server 2003
Both SQL Server services are running under the same domain account. I am
logged into my workstation with a domain account that has administrative
rights on both SQL Servers.
Note these are both SQL Server 2005 SP2 - I've had old hotfixes pointed out
to me, but those are already applied.
"Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server,
Error: 18456)"
Server A is SQL 2005 windows logins only Server B is the same (SQL 2005
windows logins only)
Server A runs windows XP Server B runs Windows Server 2003
Both SQL Server services are running under the same domain account. I am
logged into my workstation with a domain account that has administrative
rights on both SQL Servers.
Note these are both SQL Server 2005 SP2 - I've had old hotfixes pointed out
to me, but those are already applied.