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

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

Followup: Default Instance for SQLExpress 2008

Show all headers | View raw

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_thread/thread/1f71bf8a9ea5b09f/1fc3348aa2c09188?hl=en&lnk=gst&q=sqlexpress+2008+default+instance#1fc3348aa2c09188

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?

Back to comp.databases.ms-sqlserver | Previous | Next — Next 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