Friday, 10 February 2012

Configure TCP/IP port during unattended instance installation

Due to security reason, I need to restrict the port number that SQL Express instances listen on. I know I can do it through the SQL Server Configuration Manger, but I like to do it programmatically. If there a way to specify the port number in conjunction with the

“SECURITYMODE=SQL” name-value pair during the instance installation with the “setup.exe”?

Thanks,

Peter

The folks in the Setup forum will have an answer for this one.

Mike

|||

Yea I got the same problem. Im doin a silent SQL installation and i set DISABLENETWORKPROTOCOLS=2 so TCP\IP is enabled after installation.
When I open up the config managed TCP\IP is enabled but IP1 and IP2 are both disabled. I need a way to enable these and change the port numbers programatically so the user will not have to do this themselves.

No comments:

Post a Comment