SQL SERVER INSTANCES

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pippo - 29 Apr 2005 14:16 GMT

Hi,
Tipically when I create a new SQLSERVER 2000 instance I
put a new port number or the same port number of my
default istance? What's better method? Why?
I'm a vb developer and I need to create a good connection
for all situation...

Thank to All
Pippo

Reply to this Message

Mike Epprecht (SQL MVP) - 29 Apr 2005 15:16 GMT

Hi

Each instance needs to use a different port. Default is also an instance.

It is best to use ports above 32000.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

> Hi,
> Tipically when I create a new SQLSERVER 2000 instance I
[quoted text clipped - 5 lines]
> Thank to All
> Pippo

Reply to this Message