Диспетчер конфигурации sql server где находится

Где находится диспетчер конфигурации sql в windows 10?

Я просто обновился до windows 10. Не удается найти диспетчер конфигурации sql server. У меня установлены MSSQL 2008 и 2014, но нет configuration manager в All Apps .

Это просто картина, как я использую, чтобы найти его в windows 8.1, в windows 10 есть SQL Server Management Studio, но нет конфигурации, как было в windows 8.1

2 ответов

в более поздних версиях SQL Server configuration manager реализован как подключаемый модуль MMC.

есть два способа доступа к этому:

1. перейти к c:\windows\system32 и ищите файл с именем SQLServerManagernn.МСЦ, где nn — установленная версия SQL Server. Для SQLServer 2014 это имя SQLServerManager12.msc. Вы можете дважды щелкнуть на нем, и вы увидите результат. вы можете также сделайте ярлык на рабочем столе, если хотите.
2. гораздо проще запустить Управление Компьютером апплет от Панель Управления→Администрирование→Управление Компьютером, где вы должны найти установленный configuration manager

проверить это Microsoft doc страница для диспетчера конфигурации sql server.
фрагмент (февраль 2018):

Диспетчер конфигурации sql server где находится

After installing SQL Server 2008, I cannot find the SQL Server Configuration Manager in Start / SQL Server 2008 / Configuration Tools menu.

What should I do to install this tool?

12 Answers 12

If you happen to be using Windows 8 and up, here’s how to get to it:

The newer Microsoft SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program.

It is not a stand-alone program as used in the previous versions of Microsoft Windows operating systems.

SQL Server Configuration Manager doesn’t appear as an application when running Windows 8.

To open SQL Server Configuration Manager, in the Search charm, under Apps, type:

Где находится диспетчер конфигурации sql в windows 10?

Это просто картина, как я использую, чтобы найти его в windows 8.1, в windows 10 есть SQL Server Management Studio, но нет конфигурации, как было в windows 8.1

1. перейти к c:\windows\system32 и ищите файл с именем SQLServerManagernn.МСЦ, где nn — установленная версия SQL Server. Для SQLServer 2014 это имя SQLServerManager12.msc. Вы можете дважды щелкнуть на нем, и вы увидите результат. вы можете также сделайте ярлык на рабочем столе, если хотите.
2. гораздо проще запустить Управление Компьютером апплет от Панель Управления→Администрирование→Управление Компьютером, где вы должны найти установленный configuration manager

How to use SQL Server Configuration Manager

SQL Server configuration manager is a tool provided by Microsoft SQL Server. When we install SQL Server, it is installed automatically. It is used for the following purposes.

1. Manage SQL Server services
2. To manage SQL Server network configuration (32 bit 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 console management snap-in and is in the start menu. You can find it once the installation of the SQL Server is completed. To open the configuration manager, Microsoft management console uses the “SQLServerManager<version>.msc” file. For example, if you have installed SQL Server 2019 on the server, then you can open it by running “SQLServerManager15.msc” command.

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

To open configuration manager in SQL Server 2017, press the Windows and R key together. In Run, type “SQLServerManager14.msc” command. The SQL Server configuration manager 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.

Manage SQL Server services

We can start, stop, and restart the SQL Server services using the configuration manager. In the Left pan, select the “SQL Server services.” You can view the list of SQL Server services. In my workstation, I have installed multiple instances of SQL Server. Hence, I can manage them from one place. See the following image:

Now, we can start, stop, and restart the SQL Server services. To do that, right-click on any SQL Server service and in the context menu, you can see the options to start, stop, and restart the services. See the following image:

You can also change the startup parameters, enable AlwaysOn availability features, and other advanced options from the properties. To open it, right-click on SQL Server service and click on “Properties.” See the following image:

To change SQL Server startup parameters, click on the “Startup Parameter” tab. See the following image:

To change the SQL Server service account, click on the “Log On” tab. Moreover, you can also start/stop/restart the SQL Server service and view the status of the service. See the following image:

To enable the AlwaysOn availability group, click on the “AlwaysOn High Availability” tab. See the following image:

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 can 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 11.0 configuration.” See the following image:

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

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

In the right pane, you can see the list of all the above client protocols. You can enable/disable any of the protocols. To do that, right-click on any of the protocols and select Enable/Disable. See the following image:

We can also define an alias. Alias is an alternate name that can be used to connect to SQL Server. To create a new alias, right-click on Aliases and select “New Alias.” See the following image:

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 learn more about SQL Server aliases.

Manage SQL Server network configuration

From manage SQL Server network configuration node, you 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 instance on the same server. It is the simplest protocol and does not have any configuration options. You can only disable or enable the protocols that can be done from the properties window. To do 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, right-click on the TCP/IP protocol and choose properties. See the following image:

From the “protocol” tab in the properties dialog box, you can disable or enable the protocol, define the time for how long the connection will remain active and define that whether it can listen to all IP Addresses. See the following image:

In the IP Addresses tab, you can specify the IP Address 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 choose properties. Under the protocol tab of the “Named Pipe properties” dialog box, you can specify the valid named pipe connection string in the Pipe Name text box. See the following image:

Summary

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

How to use SQL Server Configuration Manager

SQL Server configuration manager is a tool provided by Microsoft SQL Server. When we install SQL Server, it is installed automatically. It is used for the following purposes.

1. Manage SQL Server services
2. To manage SQL Server network configuration (32 bit 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 console management snap-in and is in the start menu. You can find it once the installation of the SQL Server is completed. To open the configuration manager, Microsoft management console uses the “SQLServerManager<version>.msc” file. For example, if you have installed SQL Server 2019 on the server, then you can open it by running “SQLServerManager15.msc” command.

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

To open configuration manager in SQL Server 2017, press the Windows and R key together. In Run, type “SQLServerManager14.msc” command. The SQL Server configuration manager 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.

Manage SQL Server services

We can start, stop, and restart the SQL Server services using the configuration manager. In the Left pan, select the “SQL Server services.” You can view the list of SQL Server services. In my workstation, I have installed multiple instances of SQL Server. Hence, I can manage them from one place. See the following image:

Now, we can start, stop, and restart the SQL Server services. To do that, right-click on any SQL Server service and in the context menu, you can see the options to start, stop, and restart the services. See the following image:

You can also change the startup parameters, enable AlwaysOn availability features, and other advanced options from the properties. To open it, right-click on SQL Server service and click on “Properties.” See the following image:

To change SQL Server startup parameters, click on the “Startup Parameter” tab. See the following image:

To change the SQL Server service account, click on the “Log On” tab. Moreover, you can also start/stop/restart the SQL Server service and view the status of the service. See the following image:

To enable the AlwaysOn availability group, click on the “AlwaysOn High Availability” tab. See the following image:

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 can 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 11.0 configuration.” See the following image:

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

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

In the right pane, you can see the list of all the above client protocols. You can enable/disable any of the protocols. To do that, right-click on any of the protocols and select Enable/Disable. See the following image:

We can also define an alias. Alias is an alternate name that can be used to connect to SQL Server. To create a new alias, right-click on Aliases and select “New Alias.” See the following image:

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 learn more about SQL Server aliases.

Manage SQL Server network configuration

From manage SQL Server network configuration node, you 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 instance on the same server. It is the simplest protocol and does not have any configuration options. You can only disable or enable the protocols that can be done from the properties window. To do 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, right-click on the TCP/IP protocol and choose properties. See the following image:

From the “protocol” tab in the properties dialog box, you can disable or enable the protocol, define the time for how long the connection will remain active and define that whether it can listen to all IP Addresses. See the following image:

In the IP Addresses tab, you can specify the IP Address 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 choose properties. Under the protocol tab of the “Named Pipe properties” dialog box, you can specify the valid named pipe connection string in the Pipe Name text box. See the following image:

Summary

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

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

Отсутсвует диспетчер конфигурации Microsoft SQL Server или не открывается

Для настройки работы Microsoft SQL Server на специфическом порту нужно воспользоваться диспетчером конфигураций Microsoft SQL Server. Иногда ярлык “Диспетчер конфигурации SQL Server” (“SQL Server Configuration Manager”) отсутствует.

Запуск диспетчера конфигурации вручную

Вручную можно запустить командой:

C:\Windows\SysWOW64\mmc.exe /32 «c:\Windows\SysWOW64\SQLServerManager.msc»
(для 64-битной системы)

C:\Windows\System32\mmc.exe /32 C:\Windows\system32\SQLServerManager.msc
(для x86)

Вместо SQLServerManager.msc может быть другой файл, в зависимости от версии SQL Server, например, SQLServerManager12.msc.

Ошибка ручного запуска

В случае, если команда выдает ошибку 0x8004100e:

«Не удалось подключиться к поставщику WMI. Сервер недоступен или нет разрешения на доступ. Управлять службами SQL Server 2005 можно только с помощью диспетчера конфигурации SQL Server. Недопустимый класс [0x80041010] «

нужно восстановить файл конфигурации поставщика инструментария управления Windows (WMI) для управления службами SQL Server, выполнив:

C:\Program Files (x86)\Microsoft SQL Server\90\Shared\mofcomp sqlmgmproviderxpsp2up.mof
(для 64-битной системы)

C:\Program Files\Microsoft SQL Server\90\Shared\mofcomp sqlmgmproviderxpsp2up.mof
(для x86)

Вместо C:\. \90 может быть другая папка в зависимости от номера версии SQL Server (80, 90, 100, 110, 120 ….). Кроме того, на одном ПК могло быть установлено несколько версий, нужно выбрать актуальную.

Результат запуска

После этого диспетер конфигурации можно будет запустить вручную, как показано в начале.