4. Select the "Database Engine Configuration" function.
Open the "Server Configuration" tab and specify the following property:
– Authentication Mode: Activate the "Mixed Mode (SQL Server authentication and
Windows authentication)" option button.
– Enter a password: Enter a strong password for the login ID. You can delete this password
after the installation. When installing the server, you use any SQL user with administrator
rights.
Note
Properties of a strong password
● Use at least 14 characters.
● Combine uppercase and lowercase letters, as well as special characters and
numerals (?!%+…).
● Make sure that the password is not listed in dictionaries.
● Do not use any common variants and repetition or keyboard patterns, e.g. asdfgh -
OR - 1234 abcd.
● Do not simply append a simple password with numerals or common special
characters such as $!?# to the end or beginning.
● Do not use the same password for several user accounts.
– Confirm password: Confirm the password by entering it again.
– Specify the SQL Server administrators:
Click "Add Current User" to enter the current user in the list of SQL Server administrators.
Click "Add..." to add further users or user groups, such as the user group of Windows
administrators, to the list of SQL Server administrators.
Click "Next >" to continue with the configuration.
5. After completion of the installation, perform a restart.
Installing/configuring Windows services
3.4 SQL Server 2016
Manage MyResources, Optimize MyProgramming /NX-Cam Editor
Installation Manual, 12/2019, A5E44672080B AE
57
