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!!!).
