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


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

Re: Followup: Default Instance for SQLExpress 2008

Path csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From Erland Sommarskog <esquel@sommarskog.se>
Newsgroups comp.databases.ms-sqlserver
Subject Re: Followup: Default Instance for SQLExpress 2008
Date Mon, 13 Jun 2011 00:07:59 +0200
Organization Erland Sommarskog
Lines 18
Message-ID <Xns9F0315AE87A8Yazorman@127.0.0.1> (permalink)
References <31892297-0de3-4044-b0ed-8603b8cfbb8f@hg8g2000vbb.googlegroups.com>
Mime-Version 1.0
Content-Type text/plain; charset=windows-1252
Content-Transfer-Encoding 8bit
Injection-Info mx04.eternal-september.org; posting-host="DD6dU+BfJNjsjSP4/K/V7w"; logging-data="29056"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+TFnVtIr3/4FPbtdKmgajM"
User-Agent Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock sha1:ujYH8IwF2TFZbqJHgpzfapPbKn4=
Xref x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:439

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