I am trying to create a linked server on our new sql 2008 machine. I get the following error when I try to create it (login failed for user xxxx. (Microsoft SQL Server, Error: 18456). I can sign-on to the server using ssms using the same
username/password (on the same machine I am trying to create the linked server on). I have tried creating other linked server and I get the same result.
View Complete Post