dbTalk Databases Forums  

RE: Name Change of Server

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss RE: Name Change of Server in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Stephen Strong
 
Posts: n/a

Default RE: Name Change of Server - 05-16-2004 , 06:36 PM






SQL Named Instances are always accessed via [VirtualServerName]\[SQL Instance Name]. You "may" be able to do something clever with a DNS PTR record but I've not tried it. I'm also not sure what effect this would have on the Cluster Service (don't do your testing in a production environment).

Reply With Quote
  #2  
Old   
Stephen Strong
 
Posts: n/a

Default RE: Name Change of Server - 05-16-2004 , 11:51 PM






Assuming that you don't wish to configure a client alias (cliconfg.exe) you could use a DNS CNAME alias record. For more info look up the CNAME in the windows DNS documentation.

Reply With Quote
  #3  
Old   
Rand Boyd [MSFT]
 
Posts: n/a

Default RE: Name Change of Server - 05-17-2004 , 11:29 AM



You cannot change the SQL cluster name. You will need to uninstall and
reinstall to actually cchange the name. The methods suggested will allow
users to connect uisng the name you want but will not change the actual
name.

Rand
This posting is provided "as is" with no warranties and confers no rights.


Reply With Quote
  #4  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: Name Change of Server - 05-17-2004 , 01:46 PM



Actually, you need a SRV record in the DNS server. SRV records point to IP
and port numbers.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
www.sqlpass.org

"Stephen Strong" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Assuming that you don't wish to configure a client alias (cliconfg.exe)
you could use a DNS CNAME alias record. For more info look up the CNAME in
the windows DNS documentation.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.