Bookmark and Share Subscribe Bookmark and Share

Categories

Advertisement



SQL Server 2012 Installation on Windows Server 2012

Sep
13


 « »    

╬ô├Â┬╝Ôö£├¡

Run Setup.exe from the installation media

╬ô├Â┬╝Ôö£├¡

Click Installation on the menu on the left

Then click on the installation you would like to perform, in my case I will be selecting New SQL Server stand-alone installation

╬ô├Â┬╝Ôö£├¡

Setup will check the server for prerequisites, if everything passes, press OK

╬ô├Â┬╝Ôö£├¡

Enter your product key and press Next

╬ô├Â┬╝Ôö£├¡

Accept the license terms, press Next

╬ô├Â┬╝Ôö£├¡

SQL Server 2012 Setup will check for updates, in my case I unchecked this option because I will be installing SP1 after the installation is complete.

Press Next

╬ô├Â┬╝Ôö£├¡

Setup files will be installed on your system. Press Install

╬ô├Â┬╝Ôö£├¡

Now we will proceed with the actual installation and configuration.

╬ô├Â┬╝Ôö£├¡

Select the type of installation you would like to install, in my case I will be installing SQL Server Feature Installation

Press Next

╬ô├Â┬╝Ôö£├¡

Select the component you want to include with the installation, then press Next. I typically install the following components for a basic install:

  • Database Engine Services
  • SQL Server Replication
  • Client Tools Connectivity
  • Client Tools Backwards Compatibility
  • Management Tools Ôò¼├┤Ôö£├ºÔö£Ôöñ Basic
  • Management Tools – Complete

╬ô├Â┬╝Ôö£├¡

Based on the components you select, setup will check rules to make sure those components can be installed, press Next

╬ô├Â┬╝Ôö£├¡

I will be installing using the Default Instance, press Next.

╬ô├Â┬╝Ôö£├¡

Setup will check the disk space requirements, press Next

╬ô├Â┬╝Ôö£├¡

Service Accounts Tab: In the next step you can configure the service accounts used by SQL. In my case I will be keeping all of the defaults.

Collation Tab: I will keeping the default collation setting of “SQL_Latin1_General_CP1_CI_AS”.

Press Next

╬ô├Â┬╝Ôö£├¡

Server Configuration Tab: Select the type of authentication you would like to use. In my case I am selecting mixed mode because I will be installing an application that had SQL user accounts. If you select Mixed Mode you must enter a password for the SA account. Press Add Current User or add a windows user that will be a SQL Admin

Data Directories Tab: I will be keeping the defaults, you would want to change this if your system is connected to a SAN.

File Stream Tab: I will be keeping the defaults.

Press Next

╬ô├Â┬╝Ôö£├¡

Error Reporting, press Next

╬ô├Â┬╝Ôö£├¡

Setup will check for blocking issues. Press Next

╬ô├Â┬╝Ôö£├¡

Review your installation components. Press Install

╬ô├Â┬╝Ôö£├¡

Installation will start, once the installation has completed press Close

╬ô├Â┬╝Ôö£├¡

SQL Server Management Studio is now located under Start

╬ô├Â┬╝Ôö£├¡

Launch SQL Server Management Studio and verify connectivity

╬ô├Â┬╝Ôö£├¡

╬ô├Â┬╝Ôö£├¡

╬ô├Â┬╝Ôö£├¡

╬ô├Â┬╝Ôö£├¡

╬ô├Â┬╝Ôö£├¡

╬ô├Â┬╝Ôö£├¡


    Did I save you time and headaches? Buy me a cup of coffee.
    The more coffee I drink the more articles I can write.