How can I install SQL Server 2012 Express?

Troy Wolbrink — Wed, 23 Oct 2024 19:01:25 GMT

Current revision posted to Frequently Asked Questions by Troy Wolbrink on 10/23/2024 7:01:25 PM

Note: If you already installed SQL Server 2005 Express, you should uninstall it before proceeding.

Here's a link to download SQL Server 2012 Express from the Microsoft website:
Microsoft® SQL Server® 2012 Service Pack 4 (SP4) Express

Be sure to select "SQLEXPRWT_x64_ENU.exe". The "WT" part of that means it includes SQL Server Management Studio which is really helpful for troubleshooting.

Pay special attention to the Instance Name. If it won't allow "SQLExpress", maybe use "SQL2012" instead, so you can remember which instance is based on SQL Server 2012.

Pay attention to the installation when it comes time to choose your Authentication options. Be sure to:

allow "Mixed Mode"
set the "sa" password (and REMEMBER IT!!!).