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

Re: Followup: Default Instance for SQLExpress 2008

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Followup: Default Instance for SQLExpress 2008
Date	2011-06-13 00:07 +0200
Organization	Erland Sommarskog
Message-ID	<Xns9F0315AE87A8Yazorman@127.0.0.1> (permalink)
References	<31892297-0de3-4044-b0ed-8603b8cfbb8f@hg8g2000vbb.googlegroups.com>

Show all headers | View raw

Joe Cool (joecool1969@live.com) writes:
> Is there any way around this? Can you change the instance to a default
> instance after installation?

No, you cannot change the ID of an instance.

I would guess that if you give the instance ID MSSQLSERVER that you get a 
default instance, but I have not tried it. Unattended install may also have 
some good options.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

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