Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Alias works with Linked Server but not with Studio

Author  Topic 

mharran
Starting Member

2 Posts

Posted - 2013-03-02 : 09:12:04
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?

mharran
Starting Member

2 Posts

Posted - 2013-03-02 : 10:04:44
Sorted - I remembered that when you are running a 64 bit version, you still have to set the alias up under 32 bit; I would have expected that sort of crapology to be sorted out in the 2012 version :(
Go to Top of Page
   

- Advertisement -