Re: SQL 2000 & 2005 installed side by side
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
> >>
> >
> >
>
>
>
|