dbTalk Databases Forums  

Is there necessary remove named instance alias after...

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


Discuss Is there necessary remove named instance alias after... in the microsoft.public.sqlserver.clustering forum.



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

Default Is there necessary remove named instance alias after... - 02-07-2005 , 09:57 AM






Hi,

I was told by someone that after install clustering SQL Server 2000 named
instance, it must remove that before installation made the alias. Is that
necessary? What if I leave the alias named instance in the server?

Thanks!
-Chen

Reply With Quote
  #2  
Old   
Donna Lambert [MS]
 
Posts: n/a

Default RE: Is there necessary remove named instance alias after... - 02-25-2005 , 07:46 AM






Hi Chen,
I hope I'm understanding your question correctly.
It seems that you have installed a SQL 2000 Named Instance on a Windows
2003 Cluster. This requires an alias using Named Pipes for setup to run
properly.
Your question appears to be, do you have to remove it?
Technically, no, you don't have to remove the alias. However, cluster, sql
agent, and other local applications will continue to connect to SQL using
Named Pipes. There isn't an issue with this, but if you have an
application that specifically needs to use TCP, you will want to remove the
alias, or at least change it to TCP.
Hope that helps!
Donna Lambert
Microsoft PSS
SQL Server Support


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.