Can I use same port for SQL server 2000 & 2005, i.e 1433?

On separate servers yes, but on a multi instance server no.
Only 1 application can be bound to a port at a time

-Allen



Posted by NewsLook (Trial Licence) from http://www.ghytred.com/NewsLook/about.aspx

I have a Multi instance
"Allen Kinsel" <allen.kinsel (AT) nospam (DOT) anico.com> wrote

If you have a multi instance machine the port 1433 can only be available
for one of the instances of SQL server. Usually the default instance is
assigned 1433.
-Allen


Posted by NewsLook (Trial Licence) from http://www.ghytred.com/NewsLook/about.aspx

To answer your other question about how to find out ports being used:
You may use: Netstat -a to list all the ports currently being used.

Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM
SQLTips, SQL Radio, SQL Forums, SQL Articles, SQL Tips, SQL Events, SQL
Blogs, SQL Clinic.
It's a SQL Server World. Register (Free):
http://www.sqlcommunity.com/Registra...2fdefault.aspx


"Allen Kinsel" <allen.kinsel (AT) nospam (DOT) anico.com> wrote