Sql-server – Access SQL Server Configuration Manager on a remote server

configuration-managersql serverwindows-server

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.

enter image description 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

Best Answer

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,

  1. Then to check, you can run this SQL query

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

enter image description here

Et Voilà as the French would say.

Related Question