--- title: "Stop-DbaService" description: "Stops SQL Server-related Windows services with proper dependency handling." url: "https://dbatools.io/Stop-DbaService/" availability: "Windows only" tags: ["Service", "Stop"] author: "Kirill Kravtsov (@nvarscar)" source: "https://github.com/dataplat/dbatools/blob/master/public/Stop-DbaService.ps1" last_updated: "2024-01-01" --- # Stop-DbaService ## Synopsis Stops SQL Server-related Windows services with proper dependency handling. ## Description Stops SQL Server services including Database Engine, SQL Agent, Reporting Services, Analysis Services, Integration Services, PolyBase, Launchpad, and other components across one or more computers. Automatically handles service dependencies to prevent dependency conflicts during shutdown operations. Particularly useful for planned maintenance windows, troubleshooting service issues, or preparing servers for patching and reboots. The Force parameter allows stopping dependent services automatically, which is essential when stopping Database Engine services that have SQL Agent dependencies. Supports targeting specific service types or instances, making it ideal for selective service management in multi-instance environments. Can be combined with Get-DbaService for advanced filtering and bulk operations across entire SQL Server environments. Requires Local Admin rights on destination computer(s). ## Syntax ```powershell Stop-DbaService [[-ComputerName] ] [-InstanceName ] [-SqlInstance ] [-Type ] [-Timeout ] [-Credential ] [-Force] [-EnableException] [-WhatIf] [-Confirm] [] Stop-DbaService [-InstanceName ] [-Type ] -InputObject [-Timeout ] [-Credential ] [-Force] [-EnableException] [-WhatIf] [-Confirm] [] ``` ## Examples ### Example 1: Stops the SQL Server related services on computer sqlserver2014a ```powershell PS C:\> Stop-DbaService -ComputerName sqlserver2014a ``` ### Example 2: Gets the SQL Server related services on computers sql1, sql2 and sql3 and stops them ```powershell PS C:\> 'sql1','sql2','sql3'| Get-DbaService | Stop-DbaService ``` ### Example 3: Stops the SQL Server services related to the default instance MSSQLSERVER on computers sql1 and sql2 ```powershell PS C:\> Stop-DbaService -ComputerName sql1,sql2 -Instance MSSQLSERVER ``` ### Example 4: Stops the SQL Server related services of type "SSRS" (Reporting Services) on computers in the variable... ```powershell PS C:\> Stop-DbaService -ComputerName $MyServers -Type SSRS ``` Stops the SQL Server related services of type "SSRS" (Reporting Services) on computers in the variable MyServers. ### Example 5: Stops SQL Server database engine services on sql1 forcing dependent SQL Server Agent services to stop as well ```powershell PS C:\> Stop-DbaService -ComputerName sql1 -Type Engine -Force ``` ### Required Parameters ##### -InputObject Accepts service objects directly from Get-DbaService, allowing for advanced filtering and pipeline operations. Use this approach when you need complex service filtering that goes beyond the built-in ComputerName, InstanceName, and Type parameters. | Property | Value | | --- | --- | | Alias | ServiceCollection | | Required | True | | Pipeline | true (ByValue) | | Default Value | | ### Optional Parameters ##### -ComputerName Specifies the target computer(s) containing SQL Server services to stop. Accepts multiple computer names for bulk service management. Use this when you need to stop SQL Server services across multiple servers during maintenance windows or troubleshooting scenarios. | Property | Value | | --- | --- | | Alias | cn,host,Server | | Required | False | | Pipeline | false | | Default Value | $env:COMPUTERNAME | ##### -InstanceName Targets services belonging to specific SQL Server named instances. Filters results to match only the specified instance names. Essential in multi-instance environments where you need to stop services for particular instances while leaving others running. | Property | Value | | --- | --- | | Alias | Instance | | Required | False | | Pipeline | false | | Default Value | | ##### -SqlInstance Use a combination of computername and instancename to get the SQL Server related services for specific instances on specific computers. Parameters ComputerName and InstanceName will be ignored if SqlInstance is used. | Property | Value | | --- | --- | | Alias | | | Required | False | | Pipeline | false | | Default Value | | ##### -Type Filters which SQL Server service types to stop. Valid options: Agent, Browser, Engine, FullText, SSAS, SSIS, SSRS, PolyBase, Launchpad. Use this when you need to stop specific service types across instances, such as stopping all SQL Agent services for patching while keeping Database Engine services running. | Property | Value | | --- | --- | | Alias | | | Required | False | | Pipeline | false | | Default Value | | | Accepted Values | Agent,Browser,Engine,FullText,SSAS,SSIS,SSRS,PolyBase,Launchpad | ##### -Timeout Sets the maximum wait time in seconds for each service stop operation before timing out. Default is 60 seconds, specify 0 to wait indefinitely. Increase this value for services that take longer to shut down gracefully, particularly in environments with large databases or heavy workloads. | Property | Value | | --- | --- | | Alias | | | Required | False | | Pipeline | false | | Default Value | 60 | ##### -Credential Credential object used to connect to the computer as a different user. | Property | Value | | --- | --- | | Alias | | | Required | False | | Pipeline | false | | Default Value | | ##### -Force Automatically stops dependent services when stopping SQL Server Database Engine services. Prevents dependency conflicts that would otherwise block the stop operation. Required when stopping Engine services that have dependent SQL Agent services running, as SQL Agent must be stopped first to avoid service dependency errors. | Property | Value | | --- | --- | | Alias | | | Required | False | | Pipeline | false | | Default Value | False | ##### -EnableException By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message. This avoids overwhelming you with "sea of red" exceptions, but is inconvenient because it basically disables advanced scripting. Using this switch turns this "nice by default" feature off and enables you to catch exceptions with your own try/catch. | Property | Value | | --- | --- | | Alias | | | Required | False | | Pipeline | false | | Default Value | False | ##### -WhatIf Shows what would happen if the cmdlet runs. The cmdlet is not run. | Property | Value | | --- | --- | | Alias | wi | | Required | False | | Pipeline | false | | Default Value | | ##### -Confirm Prompts you for confirmation before running the cmdlet. | Property | Value | | --- | --- | | Alias | cf | | Required | False | | Pipeline | false | | Default Value | | ## Outputs **Microsoft.SqlServer.Management.Smo.Wmi.Service** **Returns one service object per service that was stopped, with the following default display properties:** - ComputerName: The name of the computer hosting the SQL Server service - ServiceName: The Windows service name (e.g., MSSQLSERVER, SQLSERVERAGENT, SSRS) - InstanceName: The SQL Server instance name associated with the service - ServiceType: The type of SQL Server service (Engine, Agent, SSRS, SSAS, SSIS, PolyBase, Launchpad, Browser, FullText) - State: The current state of the service (Running, Stopped, etc.) - Status: The result of the stop operation (Successful, Failed) - Message: Detailed status message describing the operation result (success or failure reason) **Additional properties available via Select-Object *:** - ServiceAccount: The Windows account running the service - StartMode: The startup type (Automatic, Manual, Disabled) - Properties: Collection of additional service properties - Parent: Reference to the parent computer object When -Force is used with Engine type services, dependent services (Agent, PolyBase) are automatically stopped first to prevent service dependency conflicts. All dependent services appear in the output with their own status information. If no services match the specified parameters, no output is generated. --- Part of [dbatools](https://dbatools.io/), a free and open source PowerShell module for SQL Server administration. Full command index: https://dbatools.io/commands/