====== Install Microsoft SQL Server ====== - Open [[http://www.microsoft.com/express/sql| Microsoft SQL Server Express Edition]] in a web browser. - Click on the "Download SQL Server 2012 Express" button and log into your Microsoft account. - Select "SQL Server 2014 Express" for your platform (32-bit or 64-bit) - Then click "Continue" - Once the file is downloaded, execute it. - In the SQL Server Installation Center window, click on "Installation" - Click on "New SQL Server stand-alone installation or add features to an existing installation" - Make sure that "Include SQL Server product updates" is checked then click "Next" on the Product Updates window. - Select "Perform a new installation of SQL Server 2014, then click "Next" on the Installation Type window - Click "I accept the license terms", then click "Next" on the "License Terms" window. - On the Feature Selection window, select the following features, and then click "Next": - Database Engine Services - SQL Server Replication - SQL Client Connectivity SDK - Select "Default instance," and then click "Next" on the Instance Configuration window. - On a development machine, change the Startup types for each service to Manual. - Click "Next" on the Server Configuration window. - On the Server Configuration tab of the Database Engine Configuration window: - Change Authentication Mode to "Mixed Mode" - Type and confirm a complex "sa" account password. - Click on "Add Current User" on development machines. - Click "Add" on non-development machines and add the local administrators group. - On the Data Directories tab of the Database Engine Configuration window: - On development machines and single drive servers, change the "User database directory" to "C:\data" - On multi-drive servers: - change "User database directory" to the "DATA" drive - change "User database log directory" to the "LOG" drive - change "Temp DB directory" to the "TEMPDB" drive - Click "Next" on the Error Reporting window. - Click "Next" on the Installation Configuration Rules window. - Click "Install" on the Ready to Install window. - When the installation completes, click "Close".