Dear Experts Exchange,
We have a SQL Server 2008 server (standard edition) which hosts a number of live databases on one instance. We need to setup a new database on this sql instance which has connectivity to a website. This website needs to connect over a different port (as opposed to using the default 1433) to the new database.
We are proposing to add the new port in the 'SQL Server Configuration Manager' under the 'Sql Server Network Configuration' > 'Protocols for Mssqlserver > 'TCP/IP' properties and specifying it in the 'Ip Adresses' tab by putting a comma next to the default port 1433 and adding the new port there (this is in the 'TCP Port' box which is under the headings IP1, IP2, IP3 and IPAll).
Once the above changes have been made we are proposing to restart the MSSQLSERVER service through the Configuration Manager in order for the changes to take effect.
Are there any considerations that we need to make for this change as we don't want to affect the current live databases on this instance which we are assuming are only listening on port 1433 currently as this is the only one specified in the configuration described above?
Your advice on the above would be greatly appreciated.