RE: Is there necessary remove named instance alias after...

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Donna Lambert [MS] (dlambert_at_online.microsoft.com)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 13:46:05 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

Relevant Pages

  • Re: SQL Alias for BizTalk Databases
    ... Are you thinking of doing an alias record in DNS or cliconfg.exe ... If using a SQL alias is supported, ... |>> using SQL alias for the BizTalk database server might be the answer. ... |>> SQL cluster, point the SQL alias at the cluster and start BizTalk ...
    (microsoft.public.biztalk.general)
  • Re: Serious errors with Create view command
    ... Either you open each view as needed with a different alias and assign this ... stored in the database, ... Edit Stored Procedures opens a code editing window and saves the code you ... can't paste it INTO the view designer sql view window as that's Read ...
    (microsoft.public.fox.helpwanted)
  • Re: Ranking - dealing with ties
    ... I didn't think until too late just to post the SQL - sorry. ... qryDivScore has fields Score and Div. ... Alias Scor1) ... Alias has to be used instead of the actual query name, ...
    (microsoft.public.access.formscoding)
  • Re: Apostrophe in SQL string
    ... The security hole you open up with dynamic sql strings would ... > rights.Please do not send email directly to this alias. ... sometimes there are customers with ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help - Backup not working after trying to get ISA 2004 to log to SQL
    ... On the Alias tab, ... there was an alias set up that had <servername> as the alias, ... I did a lot of restarting the SQL, WSUS and VSS services, but didn't make ... Backup log file shows this error: ...
    (microsoft.public.windows.server.sbs)