7.1 Connecting to the database engine

7.1 Connecting to the database engine

SQL Server Management Studio (SSMS) is an integrated management and development environment provided by SQL Server 2005 and subsequent products and is the most important prerequisite for SQL Server database products. SSMS provides management capabilities for all SQL Server services and has the ability to create and execute Transact-SQL (T-SQL), Multidimensional Expressions (MDX) query languages, Data Mining Extensions (DMX), and XML Analysis (XMLA) code.

7.1.1 Installing SSMS

SSMS can be installed with an instance of SQL Server. In the feature selection interface, select Administrative Tools-Basic, which is the basic management tool for database engine installation. If you select Administrative Tools-Full, you will also install support components that support SSRS, SSAS, SSIS, and install the Database Performance optimization tool.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/5F/A8/wKiom1UqOZeQ27x5AAOKDJY1Mbs140.jpg "title=" Feature selection. png "alt=" wkiom1uqozeq27x5aaokdjy1mbs140.jpg "/>

You can find the SSMS standalone installer on the installation CD.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/5F/A0/wKioL1UqOHrTa6mDAAKz7dauh_U814.jpg "title=" Install CD. png "alt=" wkiol1uqohrta6mdaakz7dauh_u814.jpg "/>

Microsoft's Download Center also provides a standalone installer that can be found in the SQL Server Express Edition download webpage to find the SSMS standalone installer.

You can install multiple versions of SSMS on the same computer, and you can connect to various versions of the database engine. The higher version of SSMS can use the full functionality of the lower version of the database engine, whereas the lower version of SSMs cannot be added with the high-version database engine.

Tips:

The Express version will not be installed with the integrated SSMS installation and will require an additional manual installation of SSMs. Express with advanced Tools version and Express with advanced Services version can be integrated with the installation of SSMS.

7.1.2 Start SSMS

After you have installed SQL Server 2014, you can find SQL Server Management Studio on the Start menu, Microsoft SQL Server 2014. Click it to start SSMS.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/5F/A3/wKiom1UqNjLgqb04AAJLOy8_CvA249.jpg "title=" Start menu. png "alt=" wkiom1uqnjlgqb04aajloy8_cva249.jpg "/>

Tips:

SSMS is a 32-bit application developed using Visual Studio that will use the configuration of the local computer's 32-bit ODBC, SQL Server Native Client, and so on.

7.1.3 connecting to a specific server instance

After you start SSMS, the default is to connect to the database engine. You can select Analysis Services, Reporting Services, or integration services in the server type list.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/5F/A5/wKioL1UqQFyiu8_gAAD9mkHxJPs672.jpg "title=" Connect to a. png "alt=" wkiol1uqqfyiu8_gaad9mkhxjps672.jpg "/>

You need to specify the server name (or IP address) and the instance name that you are connecting to in server names. You can specify the instance name in the following two ways.

Specifies the instance name. The format is:< server name >\< instance name >. If this is the default instance, you only need to specify the server name.

Specifies the port number of the instance. Format is:< server name >,< port number >. If the port number is 1433 (typically, the default instance uses 1433 ports), you can omit the port number.

If you set an alias in the SQL Native Client 11.0 configuration (32-bit) node of SQL Server Configuration Manager, you can use aliases in server name.

7.1.4 connecting to a specific database

In the Connect to Server dialog form, click the Options button to open the Connection Properties tab to set some properties for the connection. For example, you specify to connect to a particular database, or you specify that you use some kind of network protocol.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5F/A5/wKioL1UqQVKxTHoeAAFrL_KNyEA208.jpg "title=" option. png "alt=" Wkiol1uqqvkxthoeaafrl_knyea208.jpg "/>

On the Additional Connection Parameters tab, you can enter some connection string parameters. These parameters have the highest precedence and override the parameters on other tabs. These string parameters will be sent to the database engine in clear text, and should be used sparingly in environments with high security requirements.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/5F/AA/wKiom1UqQHCSYSjvAAD1OrF3t7s284.jpg "title=" Additional connection parameters. png "alt=" wkiom1uqqhcsysjvaad1orf3t7s284.jpg "/>

This article from "SQLServer2014 series" blog, declined reprint!

7.1 Connecting to the database engine