00198260-01_IM_SQL_Server_2016_EN.pdf - 第43页

SQL Server 2016 / I nstallation Manual 12/2016 Edition 43 NOTICE Name of administrators group depends on language Please keep in mind t hat the above listed query is bui lt for English language syst ems. If your operatin…

SQL Server 2016 / Installation Manual 12/2016 Edition

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]

EXEC master..sp_addsrvrolemember @loginame = N'BUILTIN\Administrators',

@rolename = N'sysadmin'

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

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.

SQL Server 2016 / Installation Manual 12/2016 Edition