I need to install another instance of SQL. The manual for
the program I am installing tells me that if there is
already another instance there, that I cannot use port

Don't install TCP/IP sockets, use Named Pipes. It is the default protocol
for SQL. With ports, you have to worry about what your firewall lets
through and blocks, and what other applications there are. SQL Server books
online discusses this in the "Network Protocols for Named Instances"
section. You can connect to an instance as <computer_name\instance_name>
instead of just <computer_name>
--
*******************************************************************
Andy S.
andy_mcdba@yahoo.com

Always keep your your virus checker
and Microsoft products up to date. Be
suspicious of every email attachment.
I will never send or post anything other than the text of a http:// link and
will
never post the link directly to a file for download.

*******************************************************************
[quoted text, click to view]