question

Anja-6015 avatar image
0 Votes"
Anja-6015 asked Anja-6015 commented

Export SqlServer network settings

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

sql-server-general
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·

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.

0 Votes 0 ·

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

1 Vote 1 ·

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

0 Votes 0 ·
SeanGallardy-MSFT avatar image
1 Vote"
SeanGallardy-MSFT answered Anja-6015 commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

1 Vote 1 ·
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered Anja-6015 commented

Those settings are server specific. They are not really useful to import into another server. What exactly is your purpose in exporting the settings?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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.

0 Votes 0 ·