Code: Select all
Write Registry Key HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL14.TEST\MSSQLServer\SuperSocketNetLib\Tcp\IPAll\TcpDynamicPorts, 11422 (permanent)
Apply Install
Set Variable SQLTCPDynamicPN to
Read Registry Key HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL14.TEST\MSSQLServer\SuperSocketNetLib\Tcp\IPAll\TcpDynamicPorts into SQLTCPDynamicPN
MessageBox: SQL Port, TcpDynamicPorts:$SQLTCPDynamicPN$;
Comment: This would still show the old value not 11422.
If I run the installation again, then it would change the value in the registry. Looks like 'Apply Install', when called 2nd time, it works.
I plan to do this for with 'Set x64 bit mode'. And I've tried that but same result.
Any suggestion? Thanks.