SQL server configuration manager is used to configure certain settings like connection protocols, service start up, etc…
Is it possible to make these changes that is done in SQL server configuration manager by using TSQL statements, or in the SSMS?
Sql-server – How to change SQL sever configuration manager settings using TSQL
configurationsql servert-sql
Related Question
- Sql-server – SQL Server starts normally from Windows Services screen, but shows error through SQL Server Configuration Manager. Why
- Sql-server – Set method to change StartMode property using SqlServer.Management.Smo.Wmi.Service
- Sql-server – Kerberos Configuration Manager – Does it work with SQL Server 2016
- Sql-server – SQL Server 2016 – Configuration Manager WMI Problem
- Sql-server – Unable to connect to remote SQL Server instance after thorough troubleshooting
- Sql-server – Is it possible to tell if an incoming connection is using an SQL Server Alias
- Sql-server – I have SQL Server Management Studio 18 – Where I can find SQLServerManager / SQL Server Configuration Manager
Best Answer
Most settings that can't be done via sp_configure are registry based
So, you can use
xp_instance_regread
etc to change them. You'll have to find a list of registry keys yourself sorry but most are underHKLM\Software\Microsoft\Microsoft SQL Server
One examples , protocols is under
and each of these has an
Enabled
valueOne important note: you can stop SQL Server from xp_cmdshell or using SHUTDOWN but not start it of course...