I need to create a stored procedure for reporting on SQL server #1 that references a SELECT from SQL Server #2.
I linked the #2 server to server #1 but if I try to do a simple select
SELECT * from [HQ-SQL2K].Ceridian.dbo.employess I get the following error
OLE DB provider "SQLNCLI" for linked server "HQ-SQL2K" returned message "Communication link failure".
Msg 10054, Level 16, State 1, Line 0
TCP Provider: An existing connection was forcibly closed by the remote host.
Msg 18452, Level 14, State 1, Line 0
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Server #1 is Windows 2003 SP1 with SQL 2005 SP1, Server #2 is Windows 2003 SP1 with SQL 2000 SP4