Can not create a linked server between SQL Server 2008 on a desktop and my laptop

Posted by norlando on Server Fault See other posts from Server Fault or by norlando
Published on 2012-05-31T15:14:54Z Indexed on 2012/05/31 16:43 UTC
Read the original article Hit count: 528

I'm having an issue getting the linked server to connect between a desktop and my laptop. Both have SQL server 2008 and the link is coming from the desktop to my laptop. Also, both computers have Windows 7. I don't have any issues creating the linked server from my laptop to the desktop. The error I'm getting is "Login failed for user '[UserName]'. (Microsoft SQL Server, Error: 18456)." I let the user name out for security reasons. The user is an sa on both SQL servers and an admin on both computers. Does anyone have an idea what could be stopping me from creating the linked server from the desktop to my laptop?

© Server Fault or respective owner

Related posts about security

Related posts about windows-7