-->APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse
APPLIES TO: SQL Server Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse
SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers. SQL Server Configuration Manager is a Microsoft Management Console snap-in that is available from the Start menu, or can be added to any other Microsoft Management Console display. Microsoft Management Console (mmc.exe) uses the SQLServerManager<version>.msc file (such as SQLServerManager13.msc for SQL Server 2016 (13.x)) to open Configuration Manager. Here are the paths to the last four versions when Windows in installed on the C drive.
SQL Server 2017 | C:WindowsSysWOW64SQLServerManager14.msc |
SQL Server 2016 | C:WindowsSysWOW64SQLServerManager13.msc |
SQL Server 2014 (12.x) | C:WindowsSysWOW64SQLServerManager12.msc |
SQL Server 2012 (11.x) | C:WindowsSysWOW64SQLServerManager11.msc |
Note
Build intelligent, mission-critical applications using a scalable, hybrid data platform for demanding workloads. Get started with a 180-day free trial of SQL Server 2017 on Windows. Take advantage of the built-in high availability, security, and intelligence of Azure SQL Database, and use the. Bring Microsoft SQL Server 2017 to the platform of your choice. Use SQL Server 2017 on Windows, Linux, and Docker containers. This may indicate a problem with your user profile. Try creating another local admin user (it's not necessary to be a local admin for starting sql service) but will definitely be safer. Then within SQL Server Configuration Manager change the user for the service to that one, or go to services and do the same for SQL Service. This topic describes how to start, stop, pause, resume, or restart the SQL Server Database Engine, the SQL Server Agent, or the SQL Server Browser service by using SQL Server Configuration Manager, SQL Server Management Studio, net commands from a command prompt, Transact-SQL, or PowerShell. Use SQL Server Configuration Manager to start, pause, resume, or stop the services, to view service properties, or to change service properties. Use SQL Server Configuration Manager to start the Database Engine using startup parameters. For more information, see Configure Server Startup Options (SQL Server Configuration Manager). SQL Server 2019 makes it easier to manage a big data environment. It provides key elements of a data lake—Hadoop Distributed File System (HDFS), Spark, and analytics tools—deeply integrated with SQL Server and fully supported by Microsoft. Easily deploy using.
Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a stand-alone program, SQL Server Configuration Manager does not appear as an application in newer versions of Windows.
- Windows 10:
To open SQL Server Configuration Manager, on the Start Page, type SQLServerManager13.msc (for SQL Server 2016 (13.x)). For previous versions of SQL Server replace 13 with a smaller number. Clicking SQLServerManager13.msc opens the Configuration Manager. To pin the Configuration Manager to the Start Page or Task Bar, right-click SQLServerManager13.msc, and then click Open file location. In the Windows File Explorer, right-click SQLServerManager13.msc, and then click Pin to Start or Pin to taskbar. - Windows 8:
To open SQL Server Configuration Manager, in the Search charm, under Apps, type SQLServerManager<version>.msc such as SQLServerManager13.msc, and then press Enter.
SQL Server Configuration Manager and SQL Server Management Studio use Window Management Instrumentation (WMI) to view and change some server settings. WMI provides a unified way for interfacing with the API calls that manage the registry operations requested by the SQL Server tools and to provide enhanced control and manipulation over the selected SQL services of the SQL Server Configuration Manager snap-in component. For information about configuring permissions related to WMI, see Configure WMI to Show Server Status in SQL Server Tools.
To start, stop, pause, resume, or configure services on another computer by using SQL Server Configuration Manager, see Connect to Another Computer (SQL Server Configuration Manager).
Managing Services
Use SQL Server Configuration Manager to start, pause, resume, or stop the services, to view service properties, or to change service properties.
Use SQL Server Configuration Manager to start the Database Engine using startup parameters. For more information, see Configure Server Startup Options (SQL Server Configuration Manager).
Changing the Accounts Used by the Services
Manage the SQL Server services using SQL Server Configuration Manager.
Important
Always use SQL Server tools such as SQL Server Configuration Manager to change the account used by the SQL Server or SQL Server Agent services, or to change the password for the account. In addition to changing the account name, SQL Server Configuration Manager performs additional configuration such as setting permissions in the Windows Registry so that the new account can read the SQL Server settings. Other tools such as the Windows Services Control Manager can change the account name but do not change associated settings. If the service cannot access the SQL Server portion of the registry the service may not start properly.
As an additional benefit, passwords changed using SQL Server Configuration Manager, SMO, or WMI take affect immediately without restarting the service.
Manage Server & Client Network Protocols
SQL Server Configuration Manager allows you to configure server and client network protocols, and connectivity options. After the correct protocols are enabled, you usually do not need to change the server network connections. However, you can use SQL Server Configuration Manager if you need to reconfigure the server connections so SQL Server listens on a particular network protocol, port, or pipe. For more information about enabling protocols, see Enable or Disable a Server Network Protocol. For information about enabling access to protocols through a firewall, see Configure the Windows Firewall to Allow SQL Server Access.
SQL Server Configuration Manager allows you to manage server and client network protocols, including the ability to force protocol encryption, view alias properties, or enable/disable a protocol.
SQL Server Configuration Manager allows you to create or remove an alias, change the order in which protocols are uses, or view properties for a server alias, including:
- Server Alias - The server alias used for the computer to which the client is connecting.
- Protocol - The network protocol used for the configuration entry.
- Connection Parameters - The parameters associated with the connection address for the network protocol configuration.
The SQL Server Configuration Manager also allows you to view information about failover cluster instances, though Cluster Administrator should be used for some actions such as starting and stopping the services.
Available Network Protocols
SQL Server supports Shared Memory, TCP/IP, and Named Pipes protocols. For information about choosing a network protocols, see Configure Client Protocols. SQL Server does not support the VIA, Banyan VINES Sequenced Packet Protocol (SPP), Multiprotocol, AppleTalk, or NWLink IPX/SPX network protocols. Clients previously connecting with these protocols must select a different protocol to connect to SQL Server. You cannot use SQL Server Configuration Manager to configure the WinSock proxy. To configure the WinSock proxy, see your ISA Server documentation.
Related Tasks
-->This topic describes how to start, stop, pause, resume, or restart the SQL Server Database Engine, the SQL Server Agent, or the SQL Server Browser service by using SQL Server Configuration Manager, SQL Server Management Studio, net commands from a command prompt, Transact-SQL, or PowerShell.
- Before you begin:
- Instructions using: Bombardier traxter 500 manual.
Before You Begin
What is the SQL Server Database Engine service, the SQL Server Agent service, and the SQL Server Browser service?
SQL Server components are executable programs that run as a Windows service. Programs that run as a Windows service can continue to operate without displaying any activity on the computer screen.
Database Engine service
The executable process that is the SQL Server Database Engine. The Database Engine can be the default instance (limit one per computer), or can be one of many named instances of the Database Engine. Use SQL Server Configuration Manager to determine which instances of Database Engine 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, SQL Server Express is installed as SQL Server (SQLEXPRESS).
The executable process that is the SQL Server Database Engine. The Database Engine can be the default instance (limit one per computer), or can be one of many named instances of the Database Engine. Use SQL Server Configuration Manager to determine which instances of Database Engine 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, SQL Server Express is installed as SQL Server (SQLEXPRESS).
SQL Server Agent service
A Windows service that 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 SQL Server. For a list of features that are supported by the editions of SQL Server, see Features Supported by the Editions of SQL Server 2016.
A Windows service that 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 SQL Server. For a list of features that are supported by the editions of SQL Server, see Features Supported by the Editions of SQL Server 2016.
SQL Server Browser service
A Windows service that listens for incoming requests for SQL Server resources and provides clients information about SQL Server instances installed on the computer. A single instance of the SQL Server Browser service is used for all instances of SQL Server installed on the computer.
A Windows service that listens for incoming requests for SQL Server resources and provides clients information about SQL Server instances installed on the computer. A single instance of the SQL Server Browser service is used for all instances of SQL Server installed on the computer.
Additional Information
- Pausing the Database Engine service prevents new users from connecting to the Database Engine, but users who are already connected can continue to work until their connections are broken. Use pause when you want to wait for users to complete work before you stop the service. This enables them to complete transactions that are in progress. Resume allows the Database Engine to accept new connections again. The SQL Server Agent service cannot be paused or resumed.
- The SQL Server Configuration Manager and SQL Server Management Studio display the current status of services by using the following icons.SQL Server Configuration Manager
- A green arrow on the icon next to the service name indicates that the service is started.
- A red square on the icon next to the service name indicates that the service is stopped.
- Two vertical blue lines on the icon next to the service name indicates that the service is paused.
- When restarting the Database Engine, a red square will indicate that the service stopped, and then a green arrow will indicate that he service started successfully.
Mozilla ftp for windows. SQL Server Management Studio- A white arrow on a green circle icon next to the service name indicates that the service is started.
- A white square on a red circle icon next to the service name indicates that the service is stopped.
- Two vertical white lines on a blue circle icon next to the service name indicates that the service is paused.
- When using SQL Server Configuration Manager or SQL Server Management Studio, only options that are possible will be available. For example, if the service is already started, Start will be unavailable.
- When running on a cluster, the SQL Server Database Engine service is best managed by using Cluster Administrator.
Security
Permissions
By default, only members of the local administrators 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.)
Stopping the Database Engine by using the Transact-SQLSHUTDOWN command requires membership in the sysadmin or serveradmin fixed server roles, and is not transferable.
Using SQL Server Configuration Manager
Starting SQL Server Configuration Manager
- On the Start menu, point to All Programs, point to Microsoft SQL Server 2017, point to Configuration Tools, and then click SQL Server Configuration Manager.Because SQL Server Configuration Manager is a snap-in for the Microsoft Management Console program and not a stand-alone program, SQL Server Configuration Manager does not appear as an application in newer versions of Windows. Here are the paths to the last four versions when Windows in installed on the C drive.
SQL Server 2016 C:WindowsSysWOW64SQLServerManager13.msc SQL Server 2014 (12.x) C:WindowsSysWOW64SQLServerManager12.msc SQL Server 2012 (11.x) C:WindowsSysWOW64SQLServerManager11.msc SQL Server 2008 C:WindowsSysWOW64SQLServerManager10.msc
To start, stop, pause, resume, or restart an instance of the SQL Server Database Engine
- Start SQL Server Configuration Manager, using the instructions above.
- If the User Account Control dialog box appears, click Yes.
- In SQL Server Configuration Manager, in the left pane, click SQL Server Services.
- In the results pane, right-click SQL Server (MSSQLServer) or a named instance, and then click Start, Stop, Pause, Resume, or Restart.
- Click OK to close SQL Server Configuration Manager.
Note
To start an instance of the SQL Server Database Engine with startup options, see Configure Server Startup Options (SQL Server Configuration Manager).
To 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, click Yes.
- In SQL Server Configuration Manager, in the left pane, click 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 click Start, Stop, Pause, Resume, or Restart.
- Click OK to close SQL Server Configuration Manager.
Using SQL Server Management Studio
To start, stop, pause, resume, or restart the an instance of the SQL Server Database Engine
- In Object Explorer, connect to the instance of the Database Engine, right-click the instance of the Database Engine you want to start, and then click Start, Stop, Pause, Resume, or Restart.Or, in Registered Servers, right-click the instance of the Database Engine you want to start, point to Service Control, and then click Start, Stop, Pause, Resume, or Restart.
- If the User Account Control dialog box appears, click Yes.
- When prompted if you want to perform the action, click Yes.
To start, stop, or restart the an instance of the SQL Server Agent
- In Object Explorer, connect to the instance of the Database Engine, right-click SQL Server Agent, and then click Start, Stop, or Restart.
- If the User Account Control dialog box appears, click Yes.
- When prompted if you want to perform the action, click Yes.
From the Command Prompt Window using net Commands
The Microsoft SQL Server services can be started, stopped, or paused by using Microsoft Windows net commands.
To start the default instance of the Database Engine
- From a command prompt, enter one of the following commands:net start 'SQL Server (MSSQLSERVER)'-or-net start MSSQLSERVER
To start a named instance of the Database Engine
- From a command prompt, enter one of the following commands. Replace <instancename> with the name of the instance you want to manage.net start 'SQL Server (instancename)'-or-net start MSSQL$instancename
To start the Database Engine 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 (-).net start 'SQL Server (MSSQLSERVER)' /f /m-or-net start MSSQLSERVER /f /mNoteFor more information about startup options, see Database Engine Service Startup Options.
To start the SQL Server Agent on the default instance of SQL Server
- From a command prompt, enter one of the following commands:net start 'SQL Server Agent (MSSQLSERVER)'-or-net start SQLSERVERAGENT
To start the SQL Server Agent on a named instance of SQL Server
- From a command prompt, enter one of the following commands. Replace instancename with the name of the instance you want to manage.net start 'SQL Server Agent(instancename)'-or-net start SQLAgent$instancename
For information about how to run SQL Server Agent in verbose mode for troubleshooting, see sqlagent90 Application.
To start the SQL Server Browser
- From a command prompt, enter one of the following commands:net start 'SQL Server Browser'-or-net start SQLBrowser
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.
Using Transact-SQL
The Database Engine can be stopped by using the SHUTDOWN statement.
To stop the Database Engine using Transact-SQL
- To wait for currently running Transact-SQL statements and stored procedures to finish, and then stop the Database Engine, execute the following statement.
- To stop the Database Engine immediately, execute the following statement.
For more information about the SHUTDOWN statement, see SHUTDOWN (Transact-SQL).
Using PowerShell
To start and stop Database Engine services
- In a Command Prompt window, start SQL Server PowerShell by executing the following command.
- At a SQL Server 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 Database Engine.
- To get a reference to a named instance of the Database Engine.
- To get a reference to the SQL Server Agent service on the default instance of the Database Engine.
- To get a reference to the SQL Server Agent service on a named instance of the Database Engine.
- To get a reference to the SQL Server Browser service.
- Complete the example to start and then stop the selected service.
See Also
Service Manager Microsoft Sql Server Analysis Management Objects
Overview of SQL Server Setup Documentation
View and Read SQL Server Setup Log Files
SQL Server Configuration Manager
Start SQL Server with Minimal Configuration
Features Supported by the Editions of SQL Server 2016
View and Read SQL Server Setup Log Files
SQL Server Configuration Manager
Start SQL Server with Minimal Configuration
Features Supported by the Editions of SQL Server 2016