Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: Followup: Default Instance for SQLExpress 2008

Show all headers | View raw

On Jun 12, 3:16 pm, 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 --

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

Thread

Followup: Default Instance for SQLExpress 2008 Joe Cool <joecool1969@live.com> - 2011-06-12 12:16 -0700
  Re: Followup: Default Instance for SQLExpress 2008 Erland Sommarskog <esquel@sommarskog.se> - 2011-06-13 00:07 +0200
    Re: Followup: Default Instance for SQLExpress 2008 Joe Cool <joecool1969@live.com> - 2011-06-12 15:15 -0700
      Re: Followup: Default Instance for SQLExpress 2008 Joe Cool <joecool1969@live.com> - 2011-06-12 16:06 -0700
  Re: Followup: Default Instance for SQLExpress 2008 Mark D Powell <Mark.Powell2@hp.com> - 2011-06-17 07:43 -0700

csiph-web