SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Alias works with Linked Server but not with Studio
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

mharran
Starting Member

2 Posts

Posted - 03/02/2013 :  09:12:04  Show Profile  Reply with Quote
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 - 03/02/2013 :  10:04:44  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000