Access SQL Server Configuration Manager on a remote server
All I wanted to do was add a startup parameter to SQL Server and to do that, I can use this script.


Copy the script to the remote server
Connect to the remote server on powershell

Enter-PSSession -ComputerName some_server_with_sql  -Credential some_user
Add the Traceflag startup parameter

[some_server_with_sql]: PS C:\Scripts> .\AddStartupParameters.ps1  '-Tsome_trace_flag_number'


And you are done,


Then to check, you can run this SQL query

SELECT * FROM sys.dm_server_registry WHERE registry_key LIKE '%Parameters' 




Et Voilà as the French would say.