00198015-01_IM_SQL_Server_2014_Express_EN - 第36页
SQL Server 2014 Ex press / Installation Manual 11/2015 Edition 36 ► Ensure that the co rrect SQL instance is enter ed as Server name : . The correct naming i s <ComputerName> \ <InstanceName > for user define…
SQL Server 2014 Express / Installation Manual 11/2015 Edition
35
► Expand Microsoft SQL Server 2014.
Figure 5-15: Starting SQL Server 2014 Management Studio
► Right- click the SQL Server 2014 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-16: Connecting to the SQL instance
SQL Server 2014 Express / Installation Manual 11/2015 Edition
36
► 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.
► Select the appropriate authentication method. If you have installed SQL correctly giving the
administrators group full permissions, you may use Windows Authentication.
► If you select SQL Authentication, enter the sa user name and the appropriate password.
► Click Connect to connect to the SQL instance.
SQL Server 2014 Management Studio connects to the SQL instance.
Figure 5-17: 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.
SQL Server 2014 Express / Installation Manual 11/2015 Edition
37
The Server Properties window is displayed.
Figure 5-18: Server Properties
► Click Security in the Select a page section.