Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.dougwise.org!nntpfeed.proxad.net!proxad.net!feeder1-1.proxad.net!198.186.194.247.MISMATCH!transit3.readnews.com!news-out.readnews.com!news-xxxfer.readnews.com!postnews.google.com!s41g2000prb.googlegroups.com!not-for-mail
From: Mark D Powell <Mark.Powell2@hp.com>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: Followup: Default Instance for SQLExpress 2008
Date: Fri, 17 Jun 2011 07:43:12 -0700 (PDT)
Organization: http://groups.google.com
Lines: 47
Message-ID: <541d8dd5-e753-4b48-94be-63a5c8c27563@s41g2000prb.googlegroups.com>
References: <31892297-0de3-4044-b0ed-8603b8cfbb8f@hg8g2000vbb.googlegroups.com>
NNTP-Posting-Host: 15.219.153.73
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1308322264 5268 127.0.0.1 (17 Jun 2011 14:51:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 17 Jun 2011 14:51:04 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: s41g2000prb.googlegroups.com; posting-host=15.219.153.73; posting-account=qJFqbQkAAACYQSLN0-cvP6ydkRfuOu6u
User-Agent: G2/1.0
X-Google-Web-Client: true
X-Google-Header-Order: ARLEUHCNK
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Hewlett-Packard; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; MS-RTC LM 8),gzip(gfe)
Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:465

On Jun 12, 3:16=A0pm, Joe Cool <joecool1...@live.com> wrote:
> A few weeks ago I posted an article about a problem I was having with
> SQLExpress 2008. See it here:
>
> http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thr...
>
> I would like to followup on this a bit. Specifically, the comment the
> responder made:
>
> "This is normal behaviour for the installer of SQL Express."
>
> I have installed SQLExpress 2005 and 2008 and SQL Server 2008, 2008
> and 2008 R2 on several flavors of operating systems.
>
> The setups for all flavors of SQL Server all ask if you want to
> install a default instance or a named instance. If you select a named
> instance in order to connect, you must connect to "<computername>
> \<instancename>".
>
> If you choose a default instance you connect to either "(local)" or
> "<computername>".
>
> I have found that the setup for SQLExpress 2005 doesn't even ask if
> you want to install a default instance or a named instance. I installs
> a named instance named SQLEXPRESS.
>
> So you must connect specifying "<computername>\SQLEXPRESS".
>
> Now, here's the rub. If you install SQLExpress 2008, it DOES ask if
> you want a default instance or a named instance. It suggests a named
> instance of the name SQLEXPRESS.
>
> But if you select default instance, it still installs a named instance
> and you must specify "<computername>\SQLEXPRESS" in order to connect.
>
> Why does it even ask if you want a default instance when it is going
> to ignore it?
>
> Is there any way around this? Can you change the instance to a default
> instance after installation?

I have seen several vendor desktop products that come with the SQL
Server Express edition and I suspect that the instance name change
feature is for their use as the vendors have renamed SQLEXPRESS to
their Product Name.

HTH -- Mark D Powell --