Export SqlServer network settings

Anja__ 26

Hi,

the sqlserver configuration manager has no option to export its current settings (like e.g. the information shown in network protocoll tcp/ip tab).
Is there another way to read/export these settings (registry, wmi, powershell, ...)?

thank you
Anja

Sean Gallardy - MSFT 1,886 Reputation points Microsoft Employee

2021-02-11T13:02:30.247+00:00

They are stored in the registry and can be read using the registry, wmi, etc., but why would you want to export these settings?
Anja__ 26 Reputation points

2021-02-11T13:35:49.663+00:00

For supporting customers who can/must not allow remote access to their intranet. I could send a screenshot, or type the settings into an email, but exporting would be mor efficient.
Sean Gallardy - MSFT 1,886 Reputation points Microsoft Employee

2021-02-11T13:37:54.113+00:00

Then get an output of the registry under the MSSQLxxx subkeys, that's easily automated and consumable.
Anja__ 26 Reputation points

2021-02-11T13:49:48.727+00:00

Thank you, found it. you should change this from comment to answer...

Accepted answer

Sean Gallardy - MSFT 1,886 Reputation points Microsoft Employee

2021-02-11T18:35:19.033+00:00

Is there another way to read/export these settings (registry, wmi, powershell, ...)?

The easiest method would be to export the registry keys and values under the instance you're looking to help troubleshoot or investigate which would be under the MSSQLxxx subkeys in HKLM. It's pretty easy to manipulate exported registry data.
Please sign in to rate this answer.

1 person found this answer helpful.
Anja__ 26 Reputation points

2021-02-11T20:02:42.937+00:00

Thanks again. for a quick list I am using PowerShell with
get-childitem -recurse 'get-childitem -recurse 'HKLM:\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server\MSSQLxx\MSSQLServer\SuperSocketNetLib\' | get-itemproperty | Select * -Exclude pspath,psparentpath,psprovider | format-list
Sign in to comment

1 additional answer

Tom Phillips 17,716 Reputation points

2021-02-11T20:05:49.203+00:00

Those settings are server specific. They are not really useful to import into another server. What exactly is your purpose in exporting the settings?
Please sign in to rate this answer.
Anja__ 26 Reputation points

2021-02-11T20:54:03.643+00:00

Communicating, a customer can send an export for analyzing. One scenario would be cases with no remote access, another one language settings I cannot handle. I do not (!) want to import something.
Sign in to comment