Make SQL Server 7.0 listen to multiple Ports

Question

Post reply

Make SQL Server 7.0 listen to multiple Ports

BobAtDBS

SSCarpal Tunnel

Points: 4590
More actions
December 18, 2003 at 5:18 am

#161006

Is there a way to make a SQL Server 7.0 (with all patches) listen on more than one port at the same time? I'm aware that one answer is "Upgrade to 2000", but that's not happening for a while, we'll probably jump to the next one instead.
Student of SQL and Golf, Master of Neither

Student of SQL and Golf, Master of Neither

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

Are you referrring to listen to more than one TCP ports? I don't think you can do that in SQL Server 2000 either.

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 2

SQL Server 2000 can, here's how:

http://support.microsoft.com/default.aspx?scid=kb;en-us;294453

I don't know of a KB article for SQL Server 7, but you could give the same instructions a try.

As for Yukon, it may be end of 2004, into 2005 before that version releases. There's another thread under Yukon here at SQLServerCentral.com that talks about this but I don't recall off the top of my head.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

K. Brian Kelley
@kbriankelley

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 3

Thanks Brian. Now I remembered there was a daily QOD for this subject.

BobAtDBS SSCarpal Tunnel Points: 4590 More actions · Answer 4

Yes, I was referring to TCP/IP ports. I've seen the referenced KB article, that's how I knew you can do it in 2000. The client network utility in 7.0 won't let you enter a comma or a space. I was hoping for a registry entry or another method.

Student of SQL and Golf, Master of Neither