00198260-01_IM_SQL_Server_2016_EN.pdf - 第39页
SQL Server 2016 / I nstallation Manual 12/2016 Edition 39 Figure 5-15: Security options – defining proxy account ► Select the Enable s erver proxy account check box . ► Enter your prox y account information. NOTICE See p…
SQL Server 2016 / Installation Manual 12/2016 Edition
38
SQL Server 2016 Management Studio connects to the SQL instance.
Figure 5-13: Selecting Properties of the SQL instance
► On the left side of the window, click the SQL instance you have connected to select it.
► Right- click and select Properties.
The Server Properties window is displayed.
Figure 5-14: Server Properties
► Click Security in the Select a page section.
SQL Server 2016 / Installation Manual 12/2016 Edition
39
Figure 5-15: Security options – defining proxy account
► Select the Enable server proxy account check box.
► Enter your proxy account information.
NOTICE
See product documentation for details
Since this is only a general SQL installation documentation, we cannot provide further
information on the proxy account to be used! Please refer to the documentation of your
ASM product to get more information if this setting is required and which account you
have to specify.
► Click the OK button.
SQL Server 2016 / Installation Manual 12/2016 Edition
40
5.3 Missing Settings
5.3.1 Assigning SQL SysAdmin Role to the Administrators Group
If you have missed to assign SQL SysAdmin permissions to the administrators group during the
SQL installation, some ASM setups might have problems connecting to your SQL Server.
This section describes how to solve this problem.
► Click the Start/Windows button.
► Expand the All apps group.
► Expand Microsoft SQL Server 2016
► Select Microsoft SQL Server 2016 Management Studio.
Figure 5-16: Selecting SQL Server 2016 Management Studio