Jeetendra (11/10/2010)
Hi,We have a Default SQL Server 2005 & several other named SQL Server Instances on the same box.
Now One of the application requires us to configure the SQL Named Instance on 1433.
Is this possible & if yess what are the steps to avoid the Port confliction with the Default Instance
You can assign a different port number to the default or the named instance (your choice).
Have a look under SQL Server Configuration Manager, and focus on the instance that you want to change.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle