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

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
>

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
>>
>
>

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
>>>
>>
>>
>
>

Start the SQL Server Browser service so it can tell the client the port
number of the instance you need. SQL Server 2000 has to be on at least
service pack 3, to talk to the Browser service and reliably give up port
1433. For more info, see the Books Online topic SQL Server Browser Service.
--
Rick Byham, MS
This posting is provided "AS IS" with no warranties, and confers no rights.

"Immy" <therealasianbabe@hotmail.com> wrote in message
news:evoc77Z3GHA.4228@TK2MSFTNGP06.phx.gbl...
> 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
>>>>
>>>
>>>
>>
>>
>
>

we are doing it a slightly different way. we have create aliases for the 2005
instance using a different port number.

we use the 'SQL server Client Network Utility' to create the alias to the
2005 instance. this permits our existing SQL 2000 DTS packages to access data
sources on the 2005 without resorting to complex naming schema. we are using
port 1434 for our 2005 instance -- but i know very little about port
assignments, so i cannot explain how or why this is done.

it works well for us. i am sure there are other ways to accomplish this also.

"qa4ever" wrote:

> 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
> >>
> >
> >
>
>
>