Sql server configuration manager как запустить из cmd

Отсутсвует диспетчер конфигурации 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 ….). Кроме того, на одном ПК могло быть установлено несколько версий, нужно выбрать актуальную.

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

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

Как открыть Диспетчер конфигурации SQL

после проверки программ, установленных на моей машине, он говорит, что у меня установлен SQL Server 2014. Однако я не могу получить доступ к Configuration Manager В «все приложения» меню Пуск, чтобы сделать базу данных. Я пытаюсь создать простую форму входа в Visual Studio, но при создании базы данных она говорит:

сеть-или относящиеся к экземпляру ошибка при подключении к SQL серверу.Сервер не найден или недоступен. Убедитесь, что экземпляр настроен на разрешение удаленных подключений. (поставщик: сетевые интерфейсы SQL, ошибка 50: — произошла ошибка выполнения локальной базы данных. Указанный экземпляр LocalDB не существует.)

правильно ли я понимаю, или я просто делаю что-то неправильно? Помогите с этой ошибкой, пожалуйста?

2 ответов

Если вы не нашли configuration manager в меню Пуск, вы можете попробовать это:

1. запустить mmc
2. выберите Файл->Добавить/удалить оснастку.
3. найдите оснастку «диспетчер конфигурации SQL Server»
4. нажмите Добавить, затем Ok.

вот скриншот для вашей справки:

на самом деле диспетчер конфигурации SQL Server не то же самое, что практическое руководство. Диспетчер конфигурации SQL Server предназначен для настройки протоколов и служб, связанных со всеми экземплярами SQL Server. Но для создания баз данных и управления ими требуется среда SQL Server Management Studio.

вы многие не видят SQL Server Management Studio в ваших программах, если он не был установлен вместе с SQL Server. Хотя бы ваш компьютер показывает, что SQL Server установлен, помните, что есть несколько модулей, и вы, возможно, не выбрали для установки Management Studio. На самом деле, Microsoft предлагает меньшие загрузки, которые не включают студию. В любом случае, скорее всего, вы не устанавливали среду Management studio.

1. повторно запустите установочный файл SQL Server и установите флажок для параметра среда Management Studio, если он установлен доступный.
2. или, скачать практическое руководство от Microsoft по этой ссылке: https://www.microsoft.com/en-ca/download/details.aspx?id=42299
   на этой странице вы увидите красную кнопку «Скачать». Щелкните его, а затем прокрутите вниз и выберите SQLServerManagementStudio_x64_ENu.файл EXE.
   это должно выглядеть так:

SQL Server Configuration Manager cannot be found

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?

13 Answers 13

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 server configuration manager как запустить из cmd

Start, stop, pause, resume, and restart SQL Server services

This article describes how to start, stop, pause, resume, or restart the [!INCLUDEssNoVersion] [!INCLUDEssDE], the SQL Server Agent, or the SQL Server Browser service on Windows by using SQL Server Configuration Manager, SQL Server Management Studio (SSMS), net commands from a command prompt, Transact-SQL, or PowerShell.

Identify the service

[!INCLUDEssNoVersion] components are executable programs that run as Windows services. Windows services can run without displaying any activity on the computer screen and without user interaction on the command line.

The [!INCLUDEssDE] service can be the default instance (limit one per computer) or can be one of many named instances on the computer. Use SQL Server Configuration Manager to find out which instances of the [!INCLUDEssDE] are installed on the computer. The default instance (if you install it) is listed as SQL Server (MSSQLSERVER). Named instances (if you install them) are listed as SQL Server (<instance_name>). By default, [!INCLUDEssNoVersion] is installed as SQL Server (SQLEXPRESS).

SQL Server Agent service

The SQL Server Agent service executes scheduled administrative tasks, which are called jobs and alerts. For more information, see SQL Server Agent. SQL Server Agent is not available in every edition of [!INCLUDEssNoVersion]. For a list of features that are supported by the editions of [!INCLUDEssNoVersion], see Features Supported by the Editions of SQL Server 2019.

SQL Server Browser service

The SQL Server Browser service listens for incoming requests for [!INCLUDEssNoVersion] resources and provides clients information about [!INCLUDEssNoVersion] instances installed on the computer. A single instance of the SQL Server Browser service is used by all instances of [!INCLUDEssNoVersion] installed on the computer.

If you pause the [!INCLUDEssDE] service, users who are already connected can continue to work until their connections are broken, but new users can’t connect to the [!INCLUDEssDE]. Use Pause when you want to wait for users to complete their work before you stop the service, which lets them complete transactions that are in progress. Resume allows the [!INCLUDEssDE] to accept new connections again. The SQL Server Agent service cannot be paused or resumed.

The SQL Server Configuration Manager and SSMS display the current status of services by using the following icons.

You won’t have access to all possible options when using SQL Server Configuration Manager or SSMS, depending on the state of the service. For example, if the service is already started, Start is unavailable.

When running on a cluster, the [!INCLUDEssNoVersion] [!INCLUDEssDE] service is best managed by using Cluster Administrator.

By default, only members of the local administrator group can start, stop, pause, resume, or restart a service. To grant non-administrators the ability to manage services, see How to grant users rights to manage services in Windows Server 2003. (The process is similar on other versions of Windows Server.)

Stopping the [!INCLUDEssDE] by using the Transact-SQL SHUTDOWN command requires membership in the sysadmin or serveradmin fixed server roles, and is not transferable.

SQL Server Configuration Manager

Start SQL Server Configuration Manager

On the Start menu, select All Programs > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager.

The SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program, and it may not appear as an application in some versions of Windows. See SQL Server Configuration Manager for more information.

Start, stop, pause, resume, or restart an instance of the [!INCLUDEssNoVersion] [!INCLUDEssDE]

Start SQL Server Configuration Manager, using the instructions above.

If the User Account Control dialog box appears, select Yes.

In SQL Server Configuration Manager, in the left pane, select SQL Server Services.

In the results pane, right-click SQL Server (MSSQLServer) or a named instance, and then select Start, Stop, Pause, Resume, or Restart.

Select OK to close the SQL Server Configuration Manager.

Start, stop, pause, resume, or restart the SQL Server Browser or an instance of the SQL Server Agent

Start SQL Server Configuration Manager, using the instructions above.

If the User Account Control dialog box appears, select Yes.

In SQL Server Configuration Manager, in the left pane, select SQL Server Services.

In the results pane, right-click SQL Server Browser, or SQL Server Agent (MSSQLServer) or SQL Server Agent (<instance_name>) for a named instance, and then select Start, Stop, Pause, Resume, or Restart.

Select OK to close the SQL Server Configuration Manager.

[!NOTE] SQL Server Agent cannot be paused.

SQL Server Management Studio

Start, stop, pause, resume, or restart an instance of the [!INCLUDEssDE]

In Object Explorer, connect to the instance of the [!INCLUDEssDE], right-click the instance of the [!INCLUDEssDE] you want to start, and then select Start, Stop, Pause, Resume, or Restart.

Or, in Registered Servers, right-click the instance of the [!INCLUDEssDE] you want to start, point to Service Control, and then select Start, Stop, Pause, Resume, or Restart.

If the User Account Control dialog box appears, select Yes.

When prompted if you want to act, select Yes.

Start, stop, or restart an instance of the SQL Server Agent

In Object Explorer, connect to the instance of the [!INCLUDEssDE], right-click SQL Server Agent, and then select Start, Stop, or Restart.

If the User Account Control dialog box appears, select Yes.

When prompted if you want to act, select Yes.

Command Prompt window using net commands

The [!INCLUDEssNoVersion] services can be started, stopped, or paused by using Windows net commands.

Start the default instance of the [!INCLUDEssDE]

From a command prompt, enter one of the following commands:

Start a named instance of the [!INCLUDEssDE]

From a command prompt, enter one of the following commands. Replace <instancename> with the name of the instance you want to manage.

Start the [!INCLUDEssDE] with startup options

Add startup options to the end of the net start «SQL Server (MSSQLSERVER)» statement, separated by a space. When started using net start, startup options use a slash (/) instead of a hyphen (-).

Start the SQL Server Agent on the default instance of [!INCLUDEssNoVersion]

From a command prompt, enter one of the following commands:

Start the SQL Server Agent on a named instance of [!INCLUDEssNoVersion]

From a command prompt, enter one of the following commands. Replace instancename with the name of the instance you want to manage.

For information about how to run SQL Server Agent in verbose mode for troubleshooting, see sqlagent90 Application.

Start the SQL Server Browser

From a command prompt, enter one of the following commands:

To pause or stop services from the Command Prompt window

To pause or stop services, modify the commands in the following ways.

To pause a service, replace net start with net pause.

To stop a service, replace net start with use net stop.

The [!INCLUDEssDE] can be stopped by using the SHUTDOWN statement.

To stop the [!INCLUDEssDE] using Transact-SQL

To wait for currently running Transact-SQL statements and stored procedures to finish, and then stop the [!INCLUDEssDE], execute the following statement.

To stop the [!INCLUDEssDE] immediately, execute the following statement.

For more information about the SHUTDOWN statement, see SHUTDOWN (Transact-SQL).

Start and stop [!INCLUDEssDE] services

In a Command Prompt window, start [!INCLUDEssNoVersion] PowerShell by executing the following command.

At a [!INCLUDEssNoVersion] PowerShell command prompt, by executing the following command. Replace computername with the name of your computer.

Identify the service that you want to stop or start. Pick one of the following lines. Replace instancename with the name of the named instance.

To get a reference to the default instance of the [!INCLUDEssDE].

To get a reference to a named instance of the [!INCLUDEssDE].

To get a reference to the SQL Server Agent service on the default instance of the [!INCLUDEssDE].

To get a reference to the SQL Server Agent service on a named instance of the [!INCLUDEssDE].

To get a reference to the SQL Server Browser service.

Complete the example to start and then stop the selected service.

Use the ServiceController class

You can use the ServiceController class to programmatically control the [!INCLUDEssNoVersion] service, or any other Windows service. For an example using C#, see ServiceController Class.