Hi All,

I started getting the following error on one of my linked servers.

Executed as user: DOMAIN\UserName. Login failed for user 'DOMAIN\UserName'. [SQLSTATE 28000] (Error 18456)  TCP Provider: An existing connection was forcibly closed by the remote host. [SQLSTATE 42000] (Error 10054)  Cannot open user default database. Login failed. [SQLSTATE 42000] (Error 4064)  OLE DB provider "SQLNCLI" for linked server "ServerName" returned message "Communication link failure". [SQLSTATE 01000] (Error 7412).  The step failed.

I am linking a SQL Server 2005 sp2 to SQL Server 2000 sp4. I have no clue of how to fix it.

Thanks!

Logon to the linked server and check if you have given the “DOMAIN\UserName” account “Connect” rights to the default database on the linked server.