Monday, March 26, 2012

multiple instances

Can I have multiple instances of SQL2K on Win 2K? If so, please adivse how.
Thanks.Yes. max 16 instances
"supernova" <abc@.yahoo.com> wrote in message
news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
how.
> Thanks.
>|||How do you do it?
"realgz" <gz_ho@.hotmail.com> wrote in message
news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> Yes. max 16 instances
> "supernova" <abc@.yahoo.com> wrote in message
> news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> how.
> > Thanks.
> >
> >
>|||How about SQL 7 on Win 2K?
"realgz" <gz_ho@.hotmail.com> wrote in message
news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> Yes. max 16 instances
> "supernova" <abc@.yahoo.com> wrote in message
> news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> how.
> > Thanks.
> >
> >
>|||No.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"supernova" <abc@.yahoo.com> wrote in message news:OOvxeh%23sDHA.3496@.TK2MSFTNGP11.phx.gbl...
> How about SQL 7 on Win 2K?
> "realgz" <gz_ho@.hotmail.com> wrote in message
> news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> > Yes. max 16 instances
> > "supernova" <abc@.yahoo.com> wrote in message
> > news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> > how.
> > > Thanks.
> > >
> > >
> >
> >
>|||Install SQL Server several times. Only one can be a default instance, the others has to be named
instances. You select whether to install a default or named instance (and the name) in the setup
program.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"supernova" <abc@.yahoo.com> wrote in message news:%23pCbzg%23sDHA.4056@.TK2MSFTNGP11.phx.gbl...
> How do you do it?
>
> "realgz" <gz_ho@.hotmail.com> wrote in message
> news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> > Yes. max 16 instances
> > "supernova" <abc@.yahoo.com> wrote in message
> > news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> > how.
> > > Thanks.
> > >
> > >
> >
> >
>|||Strictly speaking, SQL7 doesn't support multiple instances on a server. But
if I could stretch it a bit, I may argue that SQL7 actually supports two
instances on a server because it does support the active\active clustering
configuration, and when the SQL servers run on the same node (server), you
are in fact running two SQL7 instances on the server. Of course, this is not
the same as multiple instances supported by SQL2000.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"supernova" <abc@.yahoo.com> wrote in message
news:OOvxeh%23sDHA.3496@.TK2MSFTNGP11.phx.gbl...
> How about SQL 7 on Win 2K?
> "realgz" <gz_ho@.hotmail.com> wrote in message
> news:eJazoL%23sDHA.2304@.tk2msftngp13.phx.gbl...
> > Yes. max 16 instances
> > "supernova" <abc@.yahoo.com> wrote in message
> > news:e$LLTt9sDHA.2492@.TK2MSFTNGP12.phx.gbl...
> > > Can I have multiple instances of SQL2K on Win 2K? If so, please adivse
> > how.
> > > Thanks.
> > >
> > >
> >
> >
>

No comments:

Post a Comment