SQL Server Alias

If you need to install a named instance and point your client to that one you can do in the following way. The full article can be read below on MS, I have only supplied the 2005 way.

How to connect to a named instance of SQL Server 2005 or SQL Server 2000 by using the client tools in the earlier version of SQL Server

Configure a server alias to use TCP/IP sockets

Note To configure a server alias to use TCP/IP sockets, you must provide the server name and the TCP/IP port number.
1.
Determine the TCP/IP port number of the instance of SQL Server. SQL Server 2005
a.
Open SQL Server Configuration Manager, and then expand SQL Server 2005 Network Configuration.
b.
Click Protocols for InstanceName, and then double-click TCP/IP in the right panel.Note InstanceName is a placeholder for the named instance of SQL Server 2005.
c.
On the Protocol tab, notice the value of the Listen All item.
d.
Click the IP Addresses tab:
•
If the value of Listen All is yes, the TCP/IP port number for this instance of SQL Server 2005 is the value of the TCP Dynamic Ports item under IPAll.
•
If the value of Listen All is no, the TCP/IP port number for this instance of SQL Server 2005 is the value of the TCP Dynamic Ports item for a specific IP address.Note If the value of the TCP Dynamic Ports item is not set, you must set it yourself. For more information about how to configure a server to listen on a specific TCP port, visit the following Microsoft Developer Network (MSDN) Web site: http://msdn2.microsoft.com/en-us/library/ms177440.aspx (http://msdn2.microsoft.com/en-us/library/ms177440.aspx)
e.
Click OK.