Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Same port number for SQL server 2000 and 2005?

Author  Topic 

qingchengottawa
Starting Member

7 Posts

Posted - 2006-10-12 : 09:31:18
I have both Microsoft SQL server 2000 and 2005.
Now they are using the same TCP/IP port number:1433.
Is that OK? Do I need to specify different port numbers for 2000 and
2005?

Thanks,

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-10-12 : 10:09:03
To use them both on the same machine you'll use a named instance and configure the ports accordingly, see

http://support.microsoft.com/kb/265808
Go to Top of Page
   

- Advertisement -