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



DNS entry / Alias Expand / Collapse
Author
Message
Posted Tuesday, August 04, 2009 1:31 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 11, 2010 9:38 AM
Points: 97, Visits: 405
Hi,

I have a named server called ADRSTG01 (also name of the windows server). I created a DNS entry called ADRDB01 using the same IP. I can connect to ADRDB01 from everywhere every machines except from ADRSTG01 (who is the the original/real name). I want to do that to be able to move database from machines to machines and keeping the same connection.

Thanks,
Post #765092
Posted Tuesday, August 04, 2009 1:38 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 12, 2010 8:40 AM
Points: 190, Visits: 472
go to SQL server configuration manager/ sql native cliect config/aliases.....that should do it.....hope that is what you are looking for


Post #765099
« Prev Topic | Next Topic »


Permissions Expand / Collapse