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

Re: having two instances is that like have two products

Path	csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!nx02.iad01.newshosting.com!newshosting.com!69.16.185.21.MISMATCH!npeer03.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!h3g2000yqa.googlegroups.com!not-for-mail
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	Wed, 23 Nov 2011 09:57:00 -0800 (PST)
Organization	http://groups.google.com
Lines	34
Message-ID	<4f0ff96f-645e-45fa-9078-e30ba7849c9e@h3g2000yqa.googlegroups.com> (permalink)
References	<4eccd1a8$0$286$14726298@news.sunsite.dk> <Xns9FA67FB4B8A52Yazorman@127.0.0.1>
NNTP-Posting-Host	15.219.153.78
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
X-Trace	posting.google.com 1322071020 5306 127.0.0.1 (23 Nov 2011 17:57:00 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Wed, 23 Nov 2011 17:57:00 +0000 (UTC)
Complaints-To	groups-abuse@google.com
Injection-Info	h3g2000yqa.googlegroups.com; posting-host=15.219.153.78; posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u
User-Agent	G2/1.0
X-Google-Web-Client	true
X-Google-Header-Order	ARLUEHCNK
X-HTTP-UserAgent	Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2),gzip(gfe)
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:829

Show key headers only | 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