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 … Continue reading →

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) … Continue reading →