3. Select the "Server Configuration" function.
Open the "Service Accounts" tab and make the following settings:
– SQL Server Agent: NT Service\SQLSERVER... and Manual
– SQL Server Database Engine: NT Service\MSSQLSERVER and Automatic
– SQL Server Browser: NT AUTHORITY\LOCAL SERVICE and Disabled
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.
Installing/configuring Windows services
3.3 SQL Server 2012
Manage MyResources, Optimize MyProgramming /NX-Cam Editor
40
Installation Manual, 12/2019, A5E44672080B AE
