I have a remote machine running SQL Server 2012 on Windows 2008 and am trying to connect to it from a machine running SQL Server Express 2012 on Windows 8.
I have created an alias and am able to attach the remote machine as a linked server and browse the catalogue. When I try to connect to the alias through Management Studio, however, I get the network path was not found, error 53.
Definitely not a problem on the remote server as I can connect from a different PC running SQL Server Express 2008R2 on Windows 2003.
Any suggestions on what I should be looking at?