install sql server management studio 2012

You may choose to use mixed mode if you wish. Click Next >.įor the database engine configuration, I have chosen to use Windows Authentication Mode. Change all of the services allowed to Automatic. The Server Configuration dialogue box will allow you to configure what services of this instance you would like to automatically start. You will need to allow sufficient space for your databases to grow comfortably. Click Next >.ĭisk space requirements are then checked against what the installation requires. For the purpose of this article, I will create the SQL server instance named New_Instance. Remember, you will be using this name to access the instance you create.

This should be something informative and easy to recognize. Click Next >.įinally we are that the part of the installation wizard where we can name our new SQL server instance. This screen, like the previous checks, will give information about the check and allow you to see more details if there is something that needs to be fixed. This time it is for the Installation Rules. The wizard runs through another rule check. Extra options will just slow the server down by requiring more resources. Again, make sure that you select the options you require from creating this SQL server instance. Because we selected All Features With Defaults absolutely all of the options will be selected. The Feature Selection page lists all of the components that are going to be installed. For the scope of this article, All Features With Defaults is selected. The next option depends on your environment and what you require from this SQL server installation. Here you also have the opportunity to send Microsoft usage data for analysis. Read and if you accept the license terms click Next >. The next box in the installation wizard is the EULA. Unless your organization requires something different for licensing compliance, his should be the same key as the license key for the original instance of SQL server installed. We are going to create a new SQL server instance, so select the Perform a new installation of SQL Server 2012 and click Next >.Įnter your license key.

You may choose to skip this scan and check for updates later. The installation will then search for the latest updates. Click OK when you are finished looking the information over. Upon completion it will report what issues, if any, were found and give a detailed report if you wish to view it. The installation will now run the Setup Support Rules wizard to ensure that everything is good to go. Although it may not be the most obvious choice, select New SQL Server stand-alone installation or add features to an existing installation. The next screen asks us what type of installation we want to perform. When the auto run screen comes up, we want to select the Installation option to start the installation wizard. The first thing we need to do is acquire the installation media.

Install sql server management studio 2012