Named SQL Server Instance

  • 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


    Kindest Regards,

    Jeetendra

  • 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

  • HI,

    Is it possible to assign 1433 port to the maned SQL Server Instance.

    There is already a Default instance of SQL Server existing on this Box.

    Steps:-

    Change the Default Port to XXXX to the Default SQL Server Instance

    Restart the Default SQL Server Instance

    Change the Port to 1433 to the Named SQL Server Instance

    Restart the Named SQL Server Instance

    It this the correct STeps??


    Kindest Regards,

    Jeetendra

  • Steps:-

    Change the Default Port to XXXX to the Default SQL Server Instance

    Restart the Default SQL Server Instance

    Change the Port to 1433 to the Named SQL Server Instance

    Restart the Named SQL Server Instance

    Yes, it will be in order.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply