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

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:

Setup support rules1.jpg

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:

Product Key1.jpg

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.

License terms1.jpg

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.

Install setup files1.jpg

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.

Feature selection1.jpg

10. Click Next to continue to the Installation Rules window.

Installation rules1.jpg

11.Instance name should be DLS. Note: If the instance name here is not DLS, then the DB instance field in "MSSQL specific entries" in DLS Multinode installer must match the entry filled here.

Instance Configuration.png

12. 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.

Disk space req1.jpg

13.In Server Configuration, you can specify service startup and authentication.Under the Service Account tab, 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.

service accounts .jpg

14.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.


15.During installation of SQL Server the administrator must be defined.

a. Click Add Current User if current user is going to be the SQL Server administrator. Add any other domain user in case the current local user is not the database user to be used in DLS.

 step 15afix.png

b. Alternate configuration : Since there are numerous GVS cases where the domain or local user changed, deleted, etc, and forgotten from our engineers ,define mixed mode authentication with a strong provided password and there will always be a default user sa that we could connect using the provided password.

 step 15bfix.png

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

Error report1.jpg

17. 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.

Install config rules.jpg

18. 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.


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


This finalizes the installation process for SQL Server.