How can I install MSDE on an alternative port and what port should I use?
Do a normal MSDE installation and then go to
Windows, Start Menu, Run, SVRNETCN.EXE
This starts a program called Server Network Utility
In the dialog box that pops up - first make sure TCP/IP is ENABLED.
Do this by moving the TCP/IP protocal from the Disabled column to the Enabled column (obviously )
Next Highlight (Select) the enabled TCP/IP
Then click PROPERTIES (Lower right hand side)
Now change the port number from the default 1433 to whatever you want. Maybe try an odd number like 1435 ?
That's it - maybe just stop and restart SQL Server to make sure it kicks in...
If SVRNETCN.EXE is missing then download the SQL Tools within the free SQL Server 120 day Edition. SQL tools don't expire after 120 days - only the SQL server expires.
Another way to get to that dialog box is to right click the server instance in Enterprise Manager and go to Properties.
Also, when remotely connecting to your SQL Server from Enterprise Manager you give it the address like this:
www.yourserverdomain.com,9999
i.e. use a comma to seperate the port number - not a semi colon like you'd normally use in a web browser...
i.e. www.yourserverdomain.com:9999 doesn't work.