00198015-01_IM_SQL_Server_2014_Express_EN.pdf - 第40页

SQL Server 2014 Ex press / 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 R…

100%1 / 44
SQL Server 2014 Express / Installation Manual 11/2015 Edition
39
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 SIPLACE 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 Programs or Programs group respectively – depending on your operating
system.
Figure 5-20: Expanding "All Programs" group in Windows 7
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.