clustered instance – SQL Server Faq

HOW TO CHANGE THE DYNAMIC PORT OF THE SQL SERVER NAMED INSTANCE TO THE STATIC PORT IN A SQL SERVER 2005 CLUSTERED INSTANCE

In sql server the default instance has a listener which listens on the fixed port which is TCP port 1433. However for the named instance the port on which the sql server listens is random and is dynamically selected when the named instance of the sql server starts. So when we connect to…

UPGRADATION

HOW TO CONVERT A STANDALONE INSTANCE OF SQL SERVER INTO CLUSTERED INSTANCE

FOR SQL SERVER 2000: Case 1: If the default instance of sql server is to be upgraded to default clustered instance of sql server 2000 Note: 1) Only Default instance can be upgraded by this method 2) This Functionality is not vailable in sql server 2005 so if you want to convert…