How To Access Sql Server Configuration Manager In Windows 10

SQL Server configuration manager is a tool provided by Microsoft SQL Server. When nosotros install SQL Server, it is installed automatically. It is used for the post-obit purposes.

1. Manage SQL Server services
2. To manage SQL Server network configuration (32 flake and 64 bit)
3. To manage the SQL Server native client configuration
4. Create alias and manage client protocols

The SQL Server configuration manager is a Microsoft panel management snap-in and is in the start menu. You tin can find it one time the installation of the SQL Server is completed. To open the configuration director, Microsoft management console uses the "SQLServerManager<version>.msc" file. For example, if you have installed SQL Server 2019 on the server, and so you can open it by running "SQLServerManager15.msc" command.

How to open the SQL Server Configuration Manager in SQL Server 2017

To open configuration managing director in SQL Server 2017, printing the Windows and R key together. In Run, type "SQLServerManager14.msc" command. The SQL Server configuration director will open. Following is the list of commands that can be used to open the SQL Server configuration manager using "Run" or command prompt for different versions of SQL Server.

SQL Server version	Command
SQL Server 2019	SQLServerManager15.msc
SQL Server 2017	SQLServerManager14.msc
SQL Server 2016	SQLServerManager13.msc
SQL Server 2014	SQLServerManager12.msc
SQL Server 2012	SQLServerManager11.msc

Manage SQL Server services

Nosotros tin kickoff, stop, and restart the SQL Server services using the configuration managing director. In the Left pan, select the "SQL Server services." Yous can view the list of SQL Server services. In my workstation, I accept installed multiple instances of SQL Server. Hence, I can manage them from one identify. See the post-obit prototype:

Now, we can start, finish, and restart the SQL Server services. To do that, right-click on any SQL Server service and in the context menu, yous can meet the options to starting time, finish, and restart the services. See the following prototype:

Yous can also alter the startup parameters, enable AlwaysOn availability features, and other advanced options from the properties. To open it, correct-click on SQL Server service and click on "Properties." Run across the post-obit paradigm:

To alter SQL Server startup parameters, click on the "Startup Parameter" tab. See the post-obit image:

To change the SQL Server service account, click on the "Log On" tab. Moreover, you can also start/terminate/restart the SQL Server service and view the status of the service. Meet the following paradigm:

To enable the AlwaysOn availability group, click on the "AlwaysOn High Availability" tab. See the following paradigm:

Manage SQL Server native client configuration

SQL Server native client is a network library that the client uses to connect to the SQL Server. Using the SQL Server configuration manager, we tin perform the following tasks:

1. Change Client protocols
2. Create and configure an alias

To change the client protocols, click on "Client Protocols" under the "SQL Native client eleven.0 configuration." See the following image:

Clients can connect to the SQL Server using whatever of the following protocols.

1. Shared Memory
2. TCP/IP
3. Named Pipes

In the right pane, you lot can see the listing of all the to a higher place customer protocols. You lot can enable/disable any of the protocols. To do that, right-click on any of the protocols and select Enable/Disable. See the post-obit image:

We can too ascertain an alias. Alias is an alternating proper noun that can be used to connect to SQL Server. To create a new alias, right-click on Aliases and select "New Alias." Run into the following epitome:

In Alias – New dialog box, provide Alias Name, Port number, a protocol used to connect SQL Server and hostname of the SQL Server. See the following image:

You can read Overview of SQL Server Aliases article to acquire more virtually SQL Server aliases.

Manage SQL Server network configuration

From manage SQL Server network configuration node, you lot can enable or disable the network protocols supported by SQL Server.

1. Shared Memory
2. TCP/IP
3. Named Pipe

The Shared Memory Protocol

The Shared memory protocol is used by the clients to connect the SQL Server example on the same server. It is the simplest protocol and does not take any configuration options. You can just disable or enable the protocols that can be done from the backdrop window. To exercise that, See the following image:

The TCP/IP Protocol

Using TCP/IP protocols, computers can connect to the SQL Server instance. To configure the TCP/IP settings, correct-click on the TCP/IP protocol and choose properties. See the following image:

From the "protocol" tab in the properties dialog box, y'all tin disable or enable the protocol, ascertain the fourth dimension for how long the connection will remain agile and ascertain that whether it can listen to all IP Addresses. Meet the following image:

In the IP Addresses tab, yous can specify the IP Accost and the port number on which the SQL Server service will accept the incoming connections. See the following image:

The Named Pipe Protocol

The named pipe protocol is configured for local are network and it is used for inter-process communication. To configure a valid named pipe connection string, right-click on "Named Pipe" and cull backdrop. Nether the protocol tab of the "Named Pipe properties" dialog box, y'all tin specify the valid named piping connectedness string in the Piping Name text box. See the following image:

Summary

In this article, I have explained the SQL Server Configuration Director and how to employ it to configure SQL Server services and its configuration parameters.

• Author
• Recent Posts

Nisarg Upadhyay is a SQL Server Database Ambassador and Microsoft certified professional who has more than viii years of experience with SQL Server administration and 2 years with Oracle 10g database assistants.

He has expertise in database design, performance tuning, fill-in and recovery, HA and DR setup, database migrations and upgrades. He has completed the B.Tech from Ganpat Academy. He can be reached on nisargupadhyay87@outlook.com

Source: https://www.sqlshack.com/how-to-use-sql-server-configuration-manager/

Posted by: millerthromparsus1946.blogspot.com

Share this post