Views

Difference between revisions of "How to install Microsoft SQL Server"

The Wiki of Unify contains information on clients and devices, communications systems and unified communications. - Unify GmbH & Co. KG is a Trademark Licensee of Siemens AG.

Jump to: navigation, search
(Created page with "<div class="breadcrumb"> {{up}} How to collection and tutorials for OpenScape Deployment Service </div> 1. Open the setup program and proceed with the SQL installation. ...")
 
Line 3: Line 3:
 
</div>
 
</div>
  
1. Open the setup program and proceed with the SQL installation.
+
1. Insert the SQL Server installation media. From the root folder, double-click '''Setup.exe'''. To install from a network share, locate the root folder on the share, and then double-click '''Setup.exe'''. Proceed with the SQL installation.
  
  
2. When prompted for SQL Server '''Feature Installation''',you should individually select which feature components to install, or click a feature role to install a specific configuration.
+
2. The Installation Wizard runs the '''SQL Server Installation Center'''. To create a new installation of SQL Server, select the Installation option on the left side, and then click '''New SQL Server stand-alone installation or add features to an existing installation''':
  
3. Select the following features for installation: '''Database Engine Services''', '''Management Tools - Basic''', '''Management Tools - Complete'''.
+
3. Setup is now preparing to launch '''Setup Support Rules window'''.
  
4. Configure the SQL server instance which is used for the DLS. For this, select '''Named instanc'''e and assign an instance name, for instance, "DLS". In '''Instance root directory''', enter the root directory.
+
4. '''Setup Support Rules''' will run to identify problems that may occur during the Setup Support Files installation:
  
5. When prompted to configure Service Accounts, for the services '''SQL Server Agent''' and '''SQL Server Database Engine''', enter the data of that user which the DLS nodes utilize for connecting to the database. This user must be part of the administrators group. In '''Startup Type''', select ''Manual'' for the '''SQL Server Agent''', and ''Automatic'' for the '''SQL Server Database Engine'''.
+
5. Once this step finishes click '''OK''' to proceed to '''Product Key''' window. In the '''Product Key''' window, enter the '''Product license key''' (if required), and click '''Next''' to continue:
  
6. Determine an appropriate sorting behaviour. For '''Database Engine''', click '''Customize'''.
+
6. In the '''License Terms''' window, tick the box '''I accept the license terms''' and then click '''Next''' to continue.
  
7. For the collation, select '''Windows collation designator and sort order'''.  
+
'''You must accept the license agreement before you can continue the installation of SQL Server. Send feature usage data to Microsoft option is optional.'''
Under '''Collation designator''', select "Latin1_General_BIN". The '''Binary''' option is activated.
 
  
8. When prompted for Account Provisioning, under '''Authentication Mode''', select '''Windows authentication mode'''. Under '''Specify SQL Server administrators''', use '''Add...''' to add the adminstrator of the database machine as well as the user account which the DLS nodes utilize for connecting to the database.
 
  
9. Proceed with all SQL Installation dialogs as normal.
+
7. Click '''Install to Install Setup Files'''
  
Consult Microsoft official documentation / '''TechNet Library''' if needed to assure assistance.
+
'''Allow SQL to scan for important product updates and install them prior to any further action.'''
 +
 
 +
Setup files are necessary to perform the actual installation. Following the installation of the setup support files, you will be presented with another compatibility check. Following dialog appears once you successfully pass these checks. You can click the '''Show Details''' button under the green progress bar if you want to see the individual checks listed.Click '''Next'''.
 +
 
 +
8. In the '''Setup Role''' window, select '''SQL Server Feature Installation'''.Click '''Next''' to continue to '''Feature Selection'''.
 +
 
 +
'''In case of any warning of a setup support rule action, please take any remedy action and press Re-scan'''.
 +
 
 +
9. Select the following features for installation: '''Database Engine Services''', '''Management Tools - Basic''', '''Management Tools - Complete'''.You can also specify the shared feature directory where share features components will be installed.
 +
 
 +
10. Click '''Next''' to continue to the '''Installation Configuration Rules''' window. Setup verifies the system state of your computer before Setup continues.
 +
 
 +
11. Click Next to proceed to the Disk Space Requirements window.This is just a information page that does not require you to make any choices. Click Next to go to Server Configuration window.
 +
 
 +
 
 +
12. In '''Server Configuration''', you can specify service startup and authentication.Click on the '''Collation''' tab and then click the '''Customize''' button to specify the collation for your Database Engine and Analysis Services instance that best matches your application need.
 +
 
 +
[[File:serverstep12.jpg]]
 +
 
 +
13. Click '''Next''' to advance to '''Error Reporting'''.Tick the check box if you want to send Windows and SQL Server error reports to Microsoft.
 +
 
 +
14. '''Installation Configuration''' will run some more rules that will validate your computer configuration with the SQL Server features you have specified.Correct any errors reported in the '''Installation Configuration Rules''' screen and click on '''Next'''.
 +
 
 +
15. The '''Ready to Install''' page shows a tree view of installation options that were specified during Setup. Click on the '''Install''' button to start SQL Server installation. The Setup will first install the required prerequisites for the selected features followed by the feature installation. The '''Installation Progress''' window provides status so that you can monitor the installation progress as Setup continues.
 +
 
 +
16. When the installation is complete, click on '''Next''' to '''Complete''' window.
 +
 
 +
This finalizes the installation process for SQL Server.

Revision as of 14:13, 21 November 2014

1. Insert the SQL Server installation media. From the root folder, double-click Setup.exe. To install from a network share, locate the root folder on the share, and then double-click Setup.exe. Proceed with the SQL installation.


2. The Installation Wizard runs the SQL Server Installation Center. To create a new installation of SQL Server, select the Installation option on the left side, and then click New SQL Server stand-alone installation or add features to an existing installation:

3. Setup is now preparing to launch Setup Support Rules window.

4. Setup Support Rules will run to identify problems that may occur during the Setup Support Files installation:

5. Once this step finishes click OK to proceed to Product Key window. In the Product Key window, enter the Product license key (if required), and click Next to continue:

6. In the License Terms window, tick the box I accept the license terms and then click Next to continue.

You must accept the license agreement before you can continue the installation of SQL Server. Send feature usage data to Microsoft option is optional.


7. Click Install to Install Setup Files

Allow SQL to scan for important product updates and install them prior to any further action.

Setup files are necessary to perform the actual installation. Following the installation of the setup support files, you will be presented with another compatibility check. Following dialog appears once you successfully pass these checks. You can click the Show Details button under the green progress bar if you want to see the individual checks listed.Click Next.

8. In the Setup Role window, select SQL Server Feature Installation.Click Next to continue to Feature Selection.

In case of any warning of a setup support rule action, please take any remedy action and press Re-scan.

9. Select the following features for installation: Database Engine Services, Management Tools - Basic, Management Tools - Complete.You can also specify the shared feature directory where share features components will be installed.

10. Click Next to continue to the Installation Configuration Rules window. Setup verifies the system state of your computer before Setup continues.

11. Click Next to proceed to the Disk Space Requirements window.This is just a information page that does not require you to make any choices. Click Next to go to Server Configuration window.


12. In Server Configuration, you can specify service startup and authentication.Click on the Collation tab and then click the Customize button to specify the collation for your Database Engine and Analysis Services instance that best matches your application need.

serverstep12.jpg

13. Click Next to advance to Error Reporting.Tick the check box if you want to send Windows and SQL Server error reports to Microsoft.

14. Installation Configuration will run some more rules that will validate your computer configuration with the SQL Server features you have specified.Correct any errors reported in the Installation Configuration Rules screen and click on Next.

15. The Ready to Install page shows a tree view of installation options that were specified during Setup. Click on the Install button to start SQL Server installation. The Setup will first install the required prerequisites for the selected features followed by the feature installation. The Installation Progress window provides status so that you can monitor the installation progress as Setup continues.

16. When the installation is complete, click on Next to Complete window.

This finalizes the installation process for SQL Server.