![Microsoft sql server 2012 express sp2 with tools download](https://cdn2.cdnme.se/5447227/9-3/16_64e61dfc9606ee7f98e9879e.png)
![microsoft sql server 2012 express sp2 with tools download microsoft sql server 2012 express sp2 with tools download](https://www.nrclc.com/wp-content/uploads/2013/10/image002-300x236.png)
When it opens you are prompted to “Connect to Server.” The default should be, “Windows Authentication.” Click “Connect.”.Open up the newly installed MS SQL Server Management Studio Express (this should be in the Microsoft folder “Microsoft SQL Server 2012” located in your “Start Menu –> Programs”).We will open that and add a new database. When the MS SQL Server was installed it should have also installed the MS SQL Server Management Studio Tools. You are now finished installed MS SQL Server 2012 Express. After that you should see a bunch of items that were installed with the “Success” as the status.This might take awhile, definitely enough time to grab a soda and a snack. Now the SQL Server is finally installing itself.Click “Next” on the Error Reporting step.I have also put my login as the SQL Server Administrator. Now you are prompted to enter in a password.Since this is a local database that will not be used for production sites this is acceptable. The next screen shows the password for the accounts.The next step analyzes your hard drive space.
![microsoft sql server 2012 express sp2 with tools download microsoft sql server 2012 express sp2 with tools download](https://elearningresources.blob.core.windows.net/cloudhelp/Desktop/Content/Images_2011/marked_up/sqlmgmt_install_type.png)
The default instance name comes up as MSSQLSERVER. I have selected to have the default instance.
![Microsoft sql server 2012 express sp2 with tools download](https://cdn2.cdnme.se/5447227/9-3/16_64e61dfc9606ee7f98e9879e.png)