Installing MSSQL2008 with static port (1433) already configured.

I have created a batch file to install several applications (with as little interaction from the user as possible).  The first time the batch file installed MSSQL2008 (with a commandline configuration script - attached), the TCP port was automatically configured to be static and set to 1433.  Subsequent installation tests (each test is in a clean Virtual Machine) intalled MSSQL with the TCP port set to dyanmic.  

Although MSSQL is also installed as a named instance, the application that depends on MSSQL (Railo CFML Server) only uses hostname:port to connect to a database.

What do I need to do to insure that MSSQL installs with a static TCP port of 1433?  I really don't want the user to have to go into the SQL Server Network Configuration and manually tweak the TCP protocol.
Copy-of-sql-2008-express.ini
LVL 6
HyperBPPAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HyperBPPAuthor Commented:
BTW, I am using MSSQL 2008 Express.
0
Anthony PerkinsCommented:
Only the default instance of SQL Server uses 1433 by default.  All named instances of SQL Server use a dynamic port by default, that you can change prior to configuring the firewall.
So are you sure you are not installing named instances of SQL Server?
0
HyperBPPAuthor Commented:
I will double check the attached configuration script, and try it again.  GIve me an hour
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

HyperBPPAuthor Commented:
I tried it again, without the INSTANCENAME in the script.  Still installed itself with a dynamic port.  Any other suggestions?
0
Anthony PerkinsCommented:
I am afraid I am not following you.  The question is quite simple:
Is SQL Server installed as a named instance or not?
0
Anthony PerkinsCommented:
Never mind, I see that you are using SQL Server Express, so it will always install as a named instance.  That is why it is a dynamic port.
0
HyperBPPAuthor Commented:
Thank you for your respone.

Are you sure that SQL Express will always be dynamic?  The first time I installed MSSQL (with some variation of the current configuration file) it installed as a static port.
0
Anthony PerkinsCommented:
>>Are you sure that SQL Express will always be dynamic?<<
To the best of my knowledge SQL Server Express always installs as a named instance.  If SQL Server is installed as a named instance than it will use a dynamic port by default.

So really all you have to confirm is whether it is named instance or not.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nmcdermaidCommented:
You might find this port is saved to the registry. Take a look at this article. http://troubleshootingsql.wordpress.com/2010/03/03/how-to-change-the-tcpip-port-for-a-sql-server-instance/
Try messing with the registry and see if it alters the port. If so, alter your script to update the registry (of course you should first ascertain that the port is not in use).
0
VarshiniCommented:
The link is very useful for  sql port configuration
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.