Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Alias works with Linked Server but not with Management Studio Expand / Collapse
Author
Message
Posted Saturday, March 2, 2013 7:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, March 23, 2013 2:30 AM
Points: 3, Visits: 16
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?
Post #1425855
Posted Saturday, March 2, 2013 8:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, March 23, 2013 2:30 AM
Points: 3, Visits: 16
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
Post #1425857
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse