Is there necessary remove named instance alias after...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chen - 07 Feb 2005 15:57 GMT

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 to this Message

Donna Lambert [MS] - 25 Feb 2005 13:46 GMT

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 to this Message