Showing results for 
Search instead for 
Did you mean: 

How to use SQL Server Express with a hardcoded port

Siemens Experimenter Siemens Experimenter
Siemens Experimenter

A user wanted to add a SQL Server Express instance on a server that already had SQL Server installed, and they wanted to use a hardcoded port address, like:



First thing to note is that above is the way to refer to that SQL Server instance from both SQL Server Management Studio and the Rulestream Options dialog, using a comma instead of a colon (as you would expect) to denote the port number:



Second thing to note is that configuration of how to specify a different port is a little tricky in the SQL Server Configuration Manager.  The information at this StackOverflow post is helpful:


With that, everything worked wonderfully!