Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Named SQL Server Instance Expand / Collapse
Author
Message
Posted Wednesday, November 10, 2010 1:03 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, October 17, 2014 6:04 AM
Points: 612, Visits: 465
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

Post #1018398
Posted Wednesday, November 10, 2010 1:08 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:39 AM
Points: 1,880, Visits: 2,846
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.


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1018402
Posted Wednesday, November 10, 2010 1:53 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, October 17, 2014 6:04 AM
Points: 612, Visits: 465
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

Post #1018418
Posted Wednesday, November 10, 2010 3:10 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, August 28, 2014 2:39 AM
Points: 1,880, Visits: 2,846
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.


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1018453
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse