Linked Server with CName

• UncleBoris

  SSCrazy

  Points: 2018

  More actions

  April 22, 2015 at 11:40 pm

  #317020

  I am just checking my logic.

  I currently have a linked server between two SQL 2008 servers that works fine.

  ServerA and ServerB

  So to query from A to B I would do something like.

  select top 10 * from ServerA.clients.dbo.customers

  Works OK.

  Admin wants to implement a CName for the server. In this example it would be fully qualified like:

  OLTPDBServer.MyCompany.Com.Au (for example)

  1. I think I have to create a new linked server using this new CName to run along side the existing linked server, this way I can use either name to reference the server?

  i.e

  select top 10 * from ServerA.clients.dbo.customers

  OR

  select top 10 * from [OLTPDBServer.MyCompany.Com.Au].clients.dbo.customers

  If I only have one linked server then I can only connect via that one name - ServerA or OLTPDBServer.MyCompany.Com.Au

  Does this sound right?

  thanks

• Matan_Yungman

  SSC Eights!

  Points: 906

  More actions

  April 23, 2015 at 1:27 am

  #1792933

  Hi,

  That's correct..