00198015-01_IM_SQL_Server_2014_Express_EN - 第20页

SQL Server 2014 Ex press / Installation Manual 11/2015 Edition 20 The Database Engine Configura tion window is displayed. Figure 4-16: Database Engine Co nfiguration window with default set tings ► Click the Mixed Mode (…

SQL Server 2014 Express / Installation Manual 11/2015 Edition

The window should now look like this:

Figure 4-15: Server Configuration – completed

► Check that the Startup Type of all services is set to Automatic and verify the Account Name of

SQL Server Database Engine and SQL Server Browser.

► Click the Next > button to continue.

SQL Server 2014 Express / Installation Manual 11/2015 Edition

The Database Engine Configuration window is displayed.

Figure 4-16: Database Engine Configuration window with default settings

► Click the Mixed Mode (SQL Server authentication and Windows authentication button.

► Enter an appropriate password for the SQL sa (SysAdmin) account in the Enter password:

field.

► Repeat this password in the Confirm password: field.

CAUTION

Password must meet your security policies

Please keep in mind that the password you enter must meet the (Windows) password

policies. If your operating system / domain environment is configured only to allow

complex passwords, you will also have to use a complex password for your SQL sa

account.

► Under Specify SQL Server administrators, select the line which represents your currently

logged in account.

► Click the Remove button as displayed in the next figure.

Figure 4-17: Removing the currently added account from SQL Server administrators

SQL Server 2014 Express / Installation Manual 11/2015 Edition

After the current account has been removed, the local administrators group has to be added

instead.

► Click the Add… button.

The Select Users or Groups window is displayed.

Figure 4-18: Adding the administrators group – step 1

► Ensure that the local computer name is selected under From this location: – otherwise you will

have to select it using the Locations… button.

► Enter the name of the administrators group in the text field.

NOTICE

Naming of local administrators group depends on OS language

The name of the local administrators group may vary if you have an operating system

with another language than English.

► In this case, ensure to enter the proper name of the group.

► Click the Check Names button.