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!

The Author — Mitch Tulloch

Mitch Tulloch is a widely recognized expert on Windows administration, networking, and security. He has been repeatedly awarded Most Valuable Professional (MVP) status by Microsoft for his outstanding contributions in supporting users who deploy and use Microsoft platforms, products and solutions. Mitch has published over two hundred articles on different IT websites and magazines, and he has written or contributed to almost two dozen books and is lead author for the Windows 7 Resource Kit from Microsoft Press. For more information, see www.mtit.com .

Latest Contributions

Featured Links