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?
I figured out what the issue was. The instance of SQL Server 2008 on my laptop had the "Server authentication" set to "Windows Authentication mode" instead of "SQL Server and Windows Authentication mode." Once I switch my laptop to "SQL Server and Windows Authentication mode" the linked server worked just fine.