Post reply

Alias works with Linked Server but not with Management Studio

  • March 2, 2013 at 7:14 am

    #274809

    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?

  • March 2, 2013 at 8:05 am

    #1592677

    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 :crazy:

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply