SQL Server to sql server linked server setup
- by ScottStonehouse
Please explain what is required to set up a SQL Server linked server.
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.
The issue I am having is this error: "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (Microsoft SQL Server, Error: 18456)"