how to configure TCP port for unattended install

I've looked through every source of material on SQL Server Express unattended installs that I could get my hands on, but so far, I've come up with nothing that shows how to set the server engine's TCP port to 1433.

Since the SQL Server setup is part of a (considerably) larger install, requiring the customer to set this by hand is not really acceptable.

Is there a way to do this with a command-line parameter (etc)?

Thanks in advance

Josh

i assume you mean to set the port to not 1433 as this is the default behavior|||

No, I meant exactly what I said.

For SQL Server 2005 Express Edition, static port 1433 is *not* the default. Its default is to use port numbers randomly assigned at run-time.

Josh

|||my bad dude, forgot express has that behavior :)|||

Sorry for not getting here sooner, there is no way to configure the TCP port during installation that is built in. You should be able to write a script that does it, and that script can be called once SQL Express has been installed.

Check out the options available in SMO or the WMI providers, I believe either will give you the ability to configure this.

Regards,

Mike Wachal
SQL Express team

|||I am a newbe and do not know what "SMO" or "VMI" providers are. You eluded to a "Script" that can set the IP port for SQL Express. Any chance I can get a url or exanmple of this "script"?