Verify 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!

About The Author

Leave a Comment

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top