how to change Sql Server configuration on Powershell
say sp_configure 'max memory'
sp_configure 'remote access' ,1
What you want to do is to download dbatools as soon as possible and start using this cmdlet I think...
For the 'max memory'
Using the SQLlps module: https://docs.microsoft.com/en-us/sql/powershell/sql-server-powershell?view=sql-server-ver15
$sql16 = ls 'SQLSERVER:\SQL(local)'|? InstanceName -eq 'SQL16'
$sql16.Configuration.MaxServerMemory.ConfigValue = [Math]::Floor($sql16.Configuration.MaxServerMemory.RunValue * 1.5)
Other server memory configuration options: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver15
For sp_configure 'remote access' you will need to use DBATools modules which is not a Microsoft tool. It would be better to consult with DBATools forums as they may be better equipped and experienced to assist in the script.
--If the reply is helpful, please Upvote and Accept as answer--
17 people are following this question.