How To Install SQL Server 2008 Express Edition As Default Instance?

Problem

When you choose "Default Instance" option in the SQL Server 2008 Express Edition install process, you still get the named instance "SQLEXPRESS".

Solution

This is a bug of SQL Server 2008 Express Edition. Please see Selecting the "Default Instance" option in SQL Server 2008 Express RTM has no effect. As a workaround you can select the option to install a named instance and enter "MSSQLSERVER" as the instance name.

Other Resources

Navigator

Other Knowledgebase Articles

Basic SQL Hosting

# of Domains: 4
# of SQL Server Databases: 4
Disk Space: 50GB
Bandwidth: Unmetered
SQL Server 2014
Monthly: $4.99
More Information About Basic Shared SQL Server Hosting Plan

Express Hyper-V Hosting

Dedicated Memory:2GB
Disk Space: 100GB
Bandwidth: Unmetered
Windows 2012/2008: Free
Monthly: $11.99
More Information About Express Windows Hyper-V Server

Dedicated SQL Server

CPU: Quad-Core X3440 CPU
RAM: 16GB RAM
Disk: 2x120GB SSD + 300GB SATA
RAID: RAID 1
Bandwidth: Unmetered
Windows 2012/2008: Free
Monthly: $79.00
More Information About Dedicated SQL Server with SSD
SQL Server Hosting | ASP.NET Hosting | DotNetNuke Hosting | Windows VPS Hosting | Dedicated Windows Server Hosting