Verify the SQL Server service is running on a remote server

by Mitch Tulloch [Published on 5 Oct. 2011 / Last Updated on 5 Oct. 2011]

How to use the Get-Service Windows PowerShell cmdlet to verify that the SQL Server service is running on a remote server.

Get-Service is one of the Windows PowerShell cmdlets that can act on a remote computer by using the -ComputerName parameter. You can use the Get-Service cmdlet to quickly verify that the SQL Server service is running on a remote server. For example, if the name of the remote computer is SEA-SQL-03 then you could type the following command from the Windows PowerShell command shell:

Get-Service MSSQLServer -ComputerName SEA-SQL-03

If the SQL Server service is in fact running on the remote server, the output from this command might look like this:

Status          Name                       DisplayName

Running      MSSQLSERVER     SQL Server (MSSQLSERVER)

You can also abbreviate the above command like this:

gsv MSSQLServer –cn SEA-SQL-03

If you have feedback concerning this tip, please email me. And be sure to check out my website!

Featured Links