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!