00198260-01_IM_SQL_Server_2016_EN.pdf - 第42页

SQL Server 2016 / I nstallation Manual 12/2016 Edition 42 SQL Server 2016 Man agement Studio connects to t he SQL instance. Figure 5-19: Starting New Query ► Click the New Query button. ► Paste the following text i n the…

100%1 / 46
SQL Server 2016 / Installation Manual 12/2016 Edition
41
► Right- click the Microsoft SQL Server 2016 Management Studio.
Figure 5-17: Starting SQL Server 2016 Management Studio
► Select Run as administrator.
► Accept any possibly appearing User Account Control message by clicking its Yes button.
SQL Server 2016 Management Studio starts and the Connect to Server window is displayed.
Figure 5-18: Connecting to the SQL instance using SQL Authentication
► Ensure that the correct SQL instance is entered as Server name:.
The correct naming is <ComputerName>\<InstanceName> for user defined instances. If you
installed a default SQL instance (internal name MSSQLSERVER), you only have to enter the
computer name instead.
► Ensure that SQL Server Authentication is selected (since the administrators group does not
have proper permissions).
► Enter the Login and Password for the sa user (SysAdmin).
► Click the Connect button to connect to the SQL instance.
SQL Server 2016 / Installation Manual 12/2016 Edition
42
SQL Server 2016 Management Studio connects to the SQL instance.
Figure 5-19: Starting New Query
► Click the New Query button.
► Paste the following text in the new query window:
CREATE LOGIN [BUILTIN\Administrators] FROM WINDOWS WITH
DEFAULT_DATABASE=[master]
GO
EXEC master..sp_addsrvrolemember @loginame = N'BUILTIN\Administrators',
@rolename = N'sysadmin'
GO
Figure 5-20: Executing the query
► Click the ! Execute button.
You have now assigned the administrators group to the SQL SysAdmins role.
SQL Server 2016 / Installation Manual 12/2016 Edition
43
NOTICE
Name of administrators group depends on language
Please keep in mind that the above listed query is built for English language systems. If
your operating system has another language, you may have to modify the query to use
the appropriate group name, including the prefix.