No - it's done by SQL instance naming.
by default - which ever installation you install first, you will have the
option to either name it e.g. SQL2000 or have it installed as the default
service.
By doing this it will allow the folloing interaction.
If you simply conncet to your server, say MYSQLSERVER - by default you will
connect to the version that you chose to install as a default install. This
can be 2000 or 2005 - it's your choice.
Then lets say you install 2005 - you won't be able to use default anymore,
but you can now name it 2005, therefore, when connection to the server, you
must now connect as MYQSLSERVER\SQL2005 (or whatever you called your
instance name)
Got it? It's very easy.
Read this article and dont worry about it onlt referring to SQL2000 - it's
the same logic.
http://msdn.microsoft.com/library/de...ar_cs_9i5u.asp
Immy
"qa4ever" <qa4ever@hotmail.co.uk> wrote in message
news:%23nM8foY3GHA.1060@TK2MSFTNGP04.phx.gbl...
> Great could you point me in documentation how to configure this?
>
> And for example how the application differentiate between the different
> servers, if this is not done by unique port numbers?
>
> Thank you.
> qa4ever
>
> "Immy" <therealasianbabe@hotmail.com> wrote in message
> news:OTtiORW3GHA.3508@TK2MSFTNGP03.phx.gbl...
>> Absolutely - YES!
>> "qa4ever" <qa4ever@hotmail.co.uk> wrote in message
>> news:OSZajtU3GHA.696@TK2MSFTNGP03.phx.gbl...
>>> Hi
>>>
>>> Is it posible to have Sql 2000 and 2005 installed on same box and have
>>> them operational simultaniously, given different port and instance
>>> numbers?
>>>
>>> Thanks,
>>> Quality4Ever
>>>
>>
>>
>
>