SQL Server Home
Selecting the "Default Instance" option in SQL Server 2008 Express RTM has no effect
8/14/2008 3:22:05 AM
User(s) can reproduce this bug
When installing SQL Server 2008 Express RTM, selecting the default instance option still results in the database engine being installed as the instance named SQLEXPRESS.
As a workaround you can select the option to install a named instance and enter "MSSQLSERVER" as the instance name.
SQL Server 2008 - Express Edition
Windows Server 2008
Operating System Language
Steps to Reproduce
During setup select the "Default Instance" radio button option.
SQL Server 2008 Express is installed as the SQLEXPRESS instance.
SQL Server 208 should be installed as the default instance, as selecting in the setup options.
to post a comment.
Please enter a comment.
on 11/29/2009 at 7:45 AM
Bug still exists. I recently downloaded the "SQLEXPRADV_x64_ENU.exe" from the following page (which is linked from the main SQL Server 2008 Express download page):
This bug still seems to exist. I re-installed twice before figuring out what was going on. Is this supposed to be fixed yet?
on 4/28/2009 at 4:42 PM
The bug still appears to exist, as the download file hasn't been updated since 8/22 of last year:
This is the landing page linked to from the main SQL Express download page, so if there's an update the link should be changed. Otherwise it seems a long time to fix such a simple issue.
on 1/22/2009 at 10:25 AM
Until PCU1 becomes available, you can try the following workaround:
Select "Named Instance" radio button on the page, and manually enter "MSSQLSERVER" to install a default instance for Express instance.
on 1/13/2009 at 2:40 PM
Freshly downloaded on13th January 2009 from microsoft.com, I downloaded SQL Expresss 2008 with Advanced Services. Bug still exists.
A public update is a bit useless when the program isn't installed yet, please update your installers.
I had to remove/install a few times before I could figure out what was happening. It was easier to do that, than update all my connection strings in various applications all over the place.
on 1/6/2009 at 12:41 PM
Just an update on the issue you reported. This is fixed in PCU1 which will become public soon.
on 11/17/2008 at 6:16 AM
Now I install Sql Server 2008 Express w/Advanced Services - the same problem with default instance. Bug still exists.
on 10/2/2008 at 9:59 AM
Thanks for reporting this issue. We have another work item that had been filed already on this. I am closing this as a duplicate, but be assured that we will provide a fix for this in the first public update (PCU).
on 8/27/2008 at 1:06 PM
Bug is also present in the Sql Server 2008 Express w/Advanced Services installer (downloaded 8/27/2008). Hard to believe something like this was missed.
on 8/24/2008 at 5:25 AM
Very annoying bug. I had to reinstall SQL 2008 Express twice, before i look at the "Ready to install" page of wizard carefully and realize that something in install is buggy. It seems SQL team was under great presure for rlease date, to miss something very important in installation. Anyway, described workaround works, at least for me. Be carefull when insatlling SQL Server 2008 Express on production computers.
on 8/15/2008 at 2:58 PM
Thanks for the report! We'll investigate and let you know what we find.
to post a workaround.
Please enter a workaround.
on 12/5/2009 at 1:32 AM
1. install the "SQLEXPRESS" instance the 1st time
2. reopen the "SQL Server Installation Centre" again (under "Configuration Tools")
3. install the "Default Instanace" this time
on 2/18/2009 at 5:22 AM
on 8/14/2008 at 3:24 AM
Select the named instance option and enter "MSSQLSERVER" as the instance name.
© 2013 Microsoft