00198015-01_IM_SQL_Server_2014_Express_EN.pdf - 第41页

SQL Server 2014 Ex press / Installation Manual 11/2015 Edition 41 ► Ensure that the co rrect SQL instance is enter ed as Server name : . The correct naming i s <ComputerName> \ <InstanceName > for user define…

100%1 / 44
SQL Server 2014 Express / Installation Manual 11/2015 Edition
40
► Expand Microsoft SQL Server 2014.
Figure 5-21: Starting SQL Server 2014 Management Studio
► Right- click the SQL Server Management Studio.
► Select Run as administrator.
► Accept any possibly appearing User Account Control message by clicking its Yes button.
SQL Server 2014 Management Studio starts and the Connect to Server window is displayed.
Figure 5-22: Connecting to the SQL instance using SQL Authentication
SQL Server 2014 Express / Installation Manual 11/2015 Edition
41
► 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 2014 Management Studio connects to the SQL instance.
Figure 5-23: 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-24: Executing the query
► Click the ! Execute button.
You have now assigned the administrators group to the SQL SysAdmins role.
SQL Server 2014 Express / Installation Manual 11/2015 Edition
42
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.