00198015-01_IM_SQL_Server_2014_Express_EN - 第35页

SQL Server 2014 Ex press / Installation Manual 11/2015 Edition 35 ► Expand Microsoft SQL Server 201 4 . Figure 5-15: Starting SQL Server 2014 Management Studio ► Right - click the SQL Server 2014 Management Studio . ► Se…

SQL Server 2014 Express / Installation Manual 11/2015 Edition

5.2 Optional Settings

5.2.1 Proxy Account Setting

After installation you may enable the proxy server account option, required for some SIPLACE

products, like SIPLACE Explorer.

This setting is required if you have to use an account with permissions other than the configured

SQL service account for executing specific tasks. A more detailed description can be found in the

Microsoft Knowledge Base: http://support.microsoft.com/?id=kb;en-us;890775

► Click the Start/Windows button.

► Expand the All Programs or Programs group respectively – depending on your operating

system.

Figure 5-14: Expanding "All Programs" group in Windows 7

SQL Server 2014 Express / Installation Manual 11/2015 Edition

► 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

► 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.