title: Can't connect to SQL Server using an Alias
body: <p>I have a SQL Server 2000 install on a server that I am having weird connection issues with.  </p>
  
  <p>Using SSMS I can't connect to it using an Alias I have setup on Configuration Manager.  The Alias is set to use TCPIP which is the first protocol in the order below shared memory.  If I use the exact same server name I put into the Alias then I can connect just fine.</p>
  
  <p>I see the exact same behavior in my ASP.NET application, using the alias I get a connection failure, using the name it connects just fine.  The ASP.NET connection string is not specifying a protocol.  </p>