Views

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.

Revision as of 09:52, 21 November 2014 by Konstantinos Kontogiannis (talk | contribs) (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. ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

1. Open the setup program and 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.

3. Select the following features for installation: Database Engine Services, Management Tools - Basic, Management Tools - Complete.

4. Configure the SQL server instance which is used for the DLS. For this, select Named instance and assign an instance name, for instance, "DLS". In Instance root directory, enter the root directory.

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.

6. Determine an appropriate sorting behaviour. For Database Engine, click Customize.

7. For the collation, select Windows collation designator and sort order. 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.

Consult Microsoft official documentation / TechNet Library if needed to assure assistance.