Access SQL Server Configuration Manager on a remote server

Question

I am trying to add a traceflag as a startup parameter to a distant SQL Server 2016, installed on a Windows 2016 core server and I am following these instructions

At this point in the document:

In the console tree, expand Services and Applications, and then expand SQL Server Configuration Manager to manage the remote computer's services.

There is no SQL Server Configuration Manager here.

• Is this a permissions issue?
• Does anyone know what permission needs to be added and where so I can see SQL Server Configuration manager under Services and Applications?
• Does core have anything to do with this?

Thanks, Craig

Answer 1

All I wanted to do was add a startup parameter to SQL Server and to do that, I can use this script.

1. Copy the script to the remote server

2. Connect to the remote server on powershell

   Enter-PSSession -ComputerName some_server_with_sql -Credential some_user

3. Add the Traceflag startup parameter

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

And you are done,

4. 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.