Restarting the SQL Server Database Service and SQL Server Agent Services

Most Microsoft SQL Server configuration options can take effect immediately, but a few require the service to be restarted. To stop and restart the SQL Server service or SQL Server Agent service, right-click the service under Registered Servers or Object Explorer, and then click Start/Stop Service and Change Accounts. Use SQL Server Configuration Manager to stop and restart the service.

The following configuration options require restarting the service:

  • Startup parameters such as trace flags

  • Server authentication mode


If the password used by a service is changed, SQL Server can use the new password immediately.

  • Enabling, disabling, or changing the configuration of network protocols (using SQL Server Configuration Manager)