• 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