Skip to content

Instantly share code, notes, and snippets.

@nidr0x
Created June 11, 2018 07:32
Show Gist options
  • Save nidr0x/6a104040e2344fdef930736574b03e05 to your computer and use it in GitHub Desktop.
Save nidr0x/6a104040e2344fdef930736574b03e05 to your computer and use it in GitHub Desktop.
Powershell enable TCP SQL Server
set-itemproperty -path 'HKLM:\software\microsoft\microsoft sql server\mssql13.SQLEXPRESS\mssqlserver\supersocketnetlib\tcp\ipall' -name tcpdynamicports -value '' ; \
set-itemproperty -path 'HKLM:\software\microsoft\microsoft sql server\mssql13.SQLEXPRESS\mssqlserver\supersocketnetlib\tcp\ipall' -name tcpport -value 1433 ; \
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment