Named SQL Server Instance

Question

Named SQL Server Instance

Jeetendra

SSCrazy

Points: 2076
More actions
November 10, 2010 at 1:03 am

#228691

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

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

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

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

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

Jeetendra SSCrazy Points: 2076 More actions · Answer 2

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

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 3

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