How to install SQL Server 2012 on Windows Server 2012 or R2

This article will guide you on how to perform a new SQL Server 2012 standalone installation. An evaluation copy of SQL Server 2012 can be downloaded from here.

The following are some recommendations before installing SQL Server 2012:

  • Access to the Internet and Windows Update Services is required, since SQL Server setup will try to get updates for SQL Server during installation.
  • SQL Server 2012 side­by­side with SQL Server 2008. Click here.

Operating Systems Requirements.

Plan to install on a NTFS file system.

Do no try to install SQL Server 2012 on a compressed, encrypted or read­only drive, because setup will block the installation. Do not install SQL Server on a Domain Controller.

Verify Windows Management Instrumentation service (Control Panel ­> Administrative Tools ­> Services) is running. Configure your firewall to allow SQL Server access. Click here for more information about protocols and port numbers. The user account that is running SQL Server Setup must have administrative privileges on the computer.

SP1 for Windows Server 2008 R2, SP2 for SQL Server 2008, SP1 for Windows 7 and SP2 for Windows Vista are required. Windows XP, Windows Server 2003 and Windows Server 2000 are not supported.

At least 6.0 GB of disk space are required by SQL Server setup.

Additional software requirements and hardware requirements:

Enable .NET Framework 3.5. Click here to know how.

SQL Server includes .NET Framework 4.0 and will install it .NET Framework 4.0. Express Edition will download it from the Internet.

Step­-by­-step procedure to install SQL Server 2012

1.    Run SQL Server 2012 setup.

1

2.    Once the loading is done you will be on the Panning Screen.  Click on Installation.2

3.    Once on the Installation screen click on New SQL Server-stand-alone installation or add features to an existing installation.3

4

4.    It will load the setup process. Should only take a few second/minutes depending on the hardware.5

 

 

5.    SQL Server 2012 Setup will run a diagnostic before it will install. The Next button is only available if the rules pass or the rules do not block the installation.Click Next

6

 

6.    Product Key is required at this stage. If you do not have a key you can pick Evaluation. Click Next

7

 

7.     Next step is the License Terms. Read the license agreement and check mark I accept the license terms. Click Next.

9

8.     Product Updates screen appears. This will install any updates for SQL Server 2012.  Click Next

11

a.     If you don’t see the above window, it means that you are not connected to the internet. SQL Server 2012 requires an internet connection to update during the installation. Click Next

10

 

9.      Install Setup Files section will now install SQL Server 2012 to a temp directory. This could take five or ten minutes depending on the hardware.Click Install

12

13

10.      Once the above step is completed SQL Server 2012 will run another diagnostic to verify that can install on the OS. Click Next


15

 

a.      About the Windows Firewall warning, you can go ahead with the installation of SQL Server, but when it finishes configure your Windows Firewall to allow SQL Server access or disable it. Click here to know how to configure Windows Firewall for SQL Server access.

b.      About the Microsoft .NET Application Security warning, Setup Support Rules verifies Internet connectivity and triggers a warning if there is no Internet connection. The reason to check for Internet connection is “because .NET always tries to connect to CRL.MICROSOFT.COM on startup to check signature validation.”.

c.     Computer Domain Controller (DC) warning is only seen if you are installing it on a domain controller. This is highly not recommended. It gives your DC another layer of security issues.

d.      Neither of these warnings will prevent you from installing SQL Server.

11.     After the Setup Support Rules section you will get the loading setup screen.14

12.      Setup Roles is the next section. Decide to install specific feature, SharePoint support, or all features. For this guide we will pick SQL Server Feature Installation. 

16

13.      On the Feature Selection section, pick the features to install. For a standard install. I have picked the following.


17

18

 

14.      Through out the setup of SQL Server, it will give you the message “Please Wait…”. It takes about five to fifteen seconds.

19

15.    Installation Rules section appears. This a diagnostic to see if any of the features selected need anything special on the OS.

20

 

The “Prior Visual Studio 2010 instances requiring update.” rule verifies if Service Pack 1 for Visual Studio 2010 has been applied”

16.      On the Instance Configuration section, select a default or named instance for the installation. I left it all default, but if you have a SQL Server, make sure the drive has enough memory for feature use.
21

17.

This page is just for the purpose of reviewing disk usage. Click on the “Next” button to continue setup.

22

It is recommended to create a local user or use a domain user account to start SQLServer services.

23

24

25

If the computer is not part of a domain, use a local user account without Windows administrator permissions. You can create this account using Control Panel ­> User Accounts.

Use a Domain User Account if the service must interact with network services or access domain resources. This account should be precreated by a domain administration in your environment.

Whether you create a local user or a domain user account, the password you use to create the account must be a strong password.

You can also use built­in accounts (the Network Service account, Local Service, Local System) as service accounts. However, I would not recommend to use Local Service Account for SQL Server (MSSQLSERVER). Use Local System if you need a very high­ privileged account. It has extensive privileges on the local system.

Microsoft recommends you to specify an individual account for each service. The service accounts used for this configuration must have a strong password as mentioned above, otherwise you will get the error “Invalid or missing username or password. To continue, provide valid credentials for the SQL Server Agent service”. A strong password is one that has a combination of letters in uppercase, lowercase, numbers and special characters.

On the Database Engine Configuration page, choose the authentication mode to use for your SQL Server installation. Enter and confirm the password for the (sa) login when you choose Mixed Mode Authentication.

2628

 

Use the “Data Directories” tab on the “Database Engine Configuration” page to change the default location for data directories.

29

30

Use this page to enable FileStream on this instance. To enable it, select “Enable FILESTREAM for Transact­SQL access”. Select “Enable FILESTREAM for file I/O streaming access” to enable Win32 streaming access for FileStream.

On the “Windows share name” text box, to enter the name of the Windows share in which the FileStream data will be stored.

Select “Allow remote clients to have streaming access to FILESTREAM data” to allow remote clients to access this FileStream data on this server.

32

Select “Install Analysis Services in Multidimensional and Data Mining Mode” to install Analysis Services with support for online analytical processing databases and data mining models.

Select “Tabular Mode” to install Analysis Services with support for tabular models. Each mode is exclusive of the other.

33

On the Reporting Services Configuration page, choose to install Reporting Services on Native Mode or SharePoint Integrated Mode.

34

On the Error Reporting page, optionally clear the check box to disable error reporting.

35

The above dialog belongs to the Installation Configuration Rules. Setup will be running these rules to determine if the installation process will be blocked.

36

On the Ready to Install page, review the summary of features and components for your SQL Server installation. To proceed, click Install.

37

38

 

You are now ready to use SQL Server 2012. Enjoy it!

 

Advertisements