Monday, March 26, 2012

multiple instances

Hello,
I have a basic question about running multiple instances.
I would like to install 2 instances of SQL server 2000 sp3 and configure
both to the default port 1433.
I only need one up and running at any one time. So shut down one start up
the other.
Can this work? Or the way the "listener service" is configured during
install it will error on installing the second sql instance? or some other
problem?
Any help would be appreciated.As long as both aren't running at the same time then they can be configured
to listen on the same port. This can be done most easily with the server
network utility post installation. If you try and have both running, the
second one to start will have errors like "SuperSocket Info: Bind failed on
TCP port 1433." Why do you want to do this ?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"greg" <greg@.nospam.com> wrote in message
news:%23U1gYoQkEHA.1348@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have a basic question about running multiple instances.
> I would like to install 2 instances of SQL server 2000 sp3 and configure
> both to the default port 1433.
> I only need one up and running at any one time. So shut down one start up
> the other.
> Can this work? Or the way the "listener service" is configured during
> install it will error on installing the second sql instance? or some
> other
> problem?
>
> Any help would be appreciated.
>
>
>|||Thanks for the info.
It is a testing box. And 1 product requires case sensitivity on and one
requires it off.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:OoOVIYRkEHA.2908@.TK2MSFTNGP10.phx.gbl...
> As long as both aren't running at the same time then they can be
configured
> to listen on the same port. This can be done most easily with the server
> network utility post installation. If you try and have both running, the
> second one to start will have errors like "SuperSocket Info: Bind failed
on
> TCP port 1433." Why do you want to do this ?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "greg" <greg@.nospam.com> wrote in message
> news:%23U1gYoQkEHA.1348@.TK2MSFTNGP15.phx.gbl...
up[vbcol=seagreen]
>|||greg wrote:[vbcol=seagreen]
> Thanks for the info.
> It is a testing box. And 1 product requires case sensitivity on and
> one requires it off.
>
>
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:OoOVIYRkEHA.2908@.TK2MSFTNGP10.phx.gbl...
Why can't you run both instances at the same time?
David G.

No comments:

Post a Comment