Dedicated SQL Server Hosting Specialist LiveZilla Live Help
Sales: sales@dedicatedsqlserver.com
Support: support@dedicatedsqlserver.com
Phone: 409-877-4238



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 How-Tos
External Windows Resources
External SQL Server Resources
External Webmaster Resources
External Developer Resources

Express SQL Server

CPU: Intel Core 2 Duo E8400
CPU Speed: 3.00GHz
Cache: 6MB
RAM: 4GB RAM
Disk: 2x320GB SATA
RAID: RAID 1
Bandwidth: 1000GB
Win2008 Web or Win2003 STD: Free
IP Addresses: 8
Monthly: $149.00

Detail...

Standard SQL Server

CPU: Quad-Core Xeon E5410
CPU Speed: 2.33GHz
Cache: 12MB
RAM: 4GB RAM
Disk: 2x146GB SCSI
RAID: RAID 1
Bandwidth: 1500GB
Win2008 Web or Win2003 STD: Free
IP Addresses: 8
Monthly: $259.00

Detail...