Groups > comp.databases.ms-sqlserver > #829

Re: having two instances is that like have two products

From	Mark D Powell <Mark.Powell2@hp.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: having two instances is that like have two products
Date	2011-11-23 09:57 -0800
Organization	http://groups.google.com
Message-ID	<4f0ff96f-645e-45fa-9078-e30ba7849c9e@h3g2000yqa.googlegroups.com> (permalink)
References	<4eccd1a8$0$286$14726298@news.sunsite.dk> <Xns9FA67FB4B8A52Yazorman@127.0.0.1>

Show all headers | View raw

On Nov 23, 6:33 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Tony (johansson.anders...@telia.com) writes:
> > I mean can I just consider these two installations like two different
> > product in the SQL Servae family.
> > I want to get a better understanding about what SQl Server instances is
>
> I would say that it's more like have different versions of the same product
> installed in parallell. For instance, you can have Visual Studio 2005, 2008
> and 2010 all installed on the same machine.
>
> Although, in case of SQL Server instances, they can be identical. That is,
> same version number and same edition.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Tony, to add to what Erland posted, in order to run multiple instances
of SQL Server on one physical server you have to install each instance
separately.  You also have to patch each instance separately.  There
is some partial sharing of the binary tree structure but one instance
can be 2005 and another 2008 or all instance can be at the same
level.  Each instance naturally has its own set of services, which
means looking at the services is one way to try to determine the
instance names if you did not know them in advance.

HTH -- Mark D Powell --

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

having two instances is that like have two products "Tony" <johansson.andersson@telia.com> - 2011-11-23 11:50 +0100
  Re: having two instances is that like have two products Erland Sommarskog <esquel@sommarskog.se> - 2011-11-23 11:33 +0000
    Re: having two instances is that like have two products Mark D Powell <Mark.Powell2@hp.com> - 2011-11-23 09:57 -0800

csiph-web