6.1 Configuring SQL Server products with tools

6.1 Configuring SQL Server products with tools

Introduction to the 6.1.1 Configuration tool

SQL Server Configuration Manager (SSCM) is the most appropriate tool in order to configure the server and client for the SQL Servers product.

SSCM was first introduced from SQL Server 2005, and it can manage not only the services associated with SQL Server, but also the properties of the client.

If multiple instances are installed, SQL Server Setup may install multiple versions of SSCM on a single computer. Each version of the SSCM can be backwards compatible. For example, SQL Server 2014 SSCM can identify the associated service for a SQL Server 2012 instance, whereas SQL Server 2012 SSCM does not recognize the associated service for a SQL Server 2014 instance.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/5D/D4/wKioL1UlIFOj419SAAH3uE6avDY327.jpg "title=" Version number. png "alt=" wkiol1ulifoj419saah3ue6avdy327.jpg "/>

6.1.2 Start SSCM

On the Start menu, point to All Programs, click Microsoft SQL Server 2014, click Configuration Tools, and then select SQL Server 2014 Configuration Manager.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/5D/D8/wKiom1UlCNjDMIeIAAG11SFaR8s537.jpg "title=" Start menu. png "alt=" wkiom1ulcnjdmieiaag11sfar8s537.jpg "/>

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/5D/D8/wKiom1UlC2vCufdxAAHK4FzB2Fk548.jpg "title=" Sscm.png "alt=" Wkiom1ulc2vcufdxaahk4fzb2fk548.jpg "/>

6.1.3 Services for managing remote computers

You can create a custom Microsoft Management Console (MMC) that uses an MMC to manage another computer.

To open the Microsoft Management console, click Start, tap Run, type mmc, and then click OK. Then on the File menu, click Add/Remove Snap-in.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/5D/D8/wKiom1UlF3ni4HCyAAG3-DtLTjk239.jpg "style=" float: none; "Title=" Another computer 1.png "alt=" Wkiom1ulf3ni4hcyaag3-dtltjk239.jpg "/>

In the available snap-in list, select Computer Management. Click Add to add this snap-in to the selected snap-in list.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5D/D4/wKioL1UlGMLzcIsxAAJjg2L31Ew474.jpg "style=" float: none; "Title=" Another computer 2.png "alt=" Wkiol1ulgmlzcisxaajjg2l31ew474.jpg "/>

In the Computer Management dialog form, select Another computer in the this snap-in will always manage option group, and enter the name or IP address of another computer in the string box, or browse to a different server on the network. When you are finished, click OK.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/5D/D8/wKiom1UlF3qjcUO6AAEqiN3E-HU407.jpg "style=" float: none; "Title=" Another computer 3.png "alt=" Wkiom1ulf3qjcuo6aaeqin3e-hu407.jpg "/>

After you connect to the remote computer, click the OK button in the Add or remove snap-in form to return to the administration console. Note that the computer name in the Computer Management node of the tree pane changes.

If you also need to manage other computers in the MMC, repeat the steps above to add the other Computer Management snap-in to the console root node.

Expand Computer Management, services and applications, and the SQL Server Configuration Manager node, and then you can configure the SQL Server product for another computer.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/5D/D4/wKioL1UlGMKA6gKkAAJqNMr_fCg849.jpg "style=" float: none; "Title=" Another computer 4.png "alt=" Wkiol1ulgmka6gkkaajqnmr_fcg849.jpg "/>

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

6.1 Configuring SQL Server products with tools