How to install Office Communications Server 2007 R2 to a SQL Server Named Instance using a non default TCP/IP port

The information listed below has been tested using Microsoft SQL Server 2005 and Microsoft SQL Server 2008.

Office Communications Server 2007 Enterprise Edition R2 supports the use of non default TCP\IP port configurations for network access to its pool configuration databases that are located on the backend SQL server instance. Microsoft SQL Server supports three types of configurations for the Instances that it can host. They are:

Default Instance

The Default Instance is the instance that is installed on the SQL Server that will inherit the host name of the server that SQL Server is installed on. There can only be one Default Instance installation per SQL Server. So any instances that are installed before or after the single Default Instance will have to be a SQL Server Named Instance.

Named Instance

A Named Instance can be installed onto a SQL Server at any time. Microsoft SQL Server can support many Named Instances at one time. Named Instances will use whatever meaningful name that they were given during their installation. For specifics on the number of Named Instances the your version of SQL Server can support please query the SQL Server Books Online help tool or visit the Microsoft SQL Server website and search its technical listings.

Default Instance\Named Instance

This SQL Server installation includes an installed Default Instance along with one or more Named Instances that are installed on the Microsoft SQL Server. The Default Instance will inherit the host name of the server that Microsoft SQL Server is installed on, and any Named Instance will use whatever meaningful name that they were given during their installation. For specifics on the number of Named Instances the your version of SQL Server can support please query the SQL Server Books Online help tool or visit the Microsoft SQL Server website and search its technical listings.

Continue at source