December 18, 2003 at 5:18 am
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
December 18, 2003 at 7:02 am
Are you referrring to listen to more than one TCP ports? I don't think you can do that in SQL Server 2000 either.
December 18, 2003 at 7:06 am
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
K. Brian Kelley
@kbriankelley
December 18, 2003 at 7:13 am
Thanks Brian. Now I remembered there was a daily QOD for this subject.
December 18, 2003 at 7:26 am
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
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