At this point, SQL Server 7.0 has now been upgraded to SQL Server 2000. The next step is to add the SQL Server 2000 clustering support to the cluster, following these steps:
- If you have not done so already, log into the primary node of the SQL Server 2000 cluster using the account and password used for the mssqlserver service.
- From the SQL Server 2000 Enterprise CD, or from the local hard disk if the setup files are installed locally on drive C:, begin the SQL Server 2000 setup program.
- In the Welcome dialog box, click Next.
- In the Computer Name dialog box, select “Local Computer.”
- In the Installation dialog box, select “Upgrade, remove, or add components to an existing instance of SQL Server.”
- In the Existing Installation dialog box, select “Upgrade your existing installation to a clustered installation.”
- In the Virtual Server Name dialog box, enter the name you will be assigning to your virtual SQL Server cluster. In almost all cases, this will be the same virtual name you used for your SQL Server 7.0 cluster.
- In the Failover Clustering dialog box, enter the virtual IP address to be used for your virtual SQL Server cluster. In almost all cases, this will be the same virtual IP address you used for your SQL Server 7.0 cluster.
- In the Cluster Management dialog box, both the physical names of the nodes in your cluster should be selected to participate in the cluster. This is the default option, and should be left alone.
- In the Remote Information dialog box, enter the appropriate login credentials. Generally, this should be the name of the account and the password used for the mssqlserver service.
- In the Services Accounts dialog box, enter the name of the account and the password used for the SQL Server services. (Same as above, in most cases).
- In the Setup Completion screen, click Finish.
- Reboot the primary node of the cluster and let it restart fully.
- Reboot the secondary node of the cluster and let it restart fully.
Unfortunately, we are still not done, although we are close to being done. We still need to apply the latest SQL Server service pack to the SQL Server 2000 cluster. Here’s how:
- If you have not yet done so, get a copy of the latest SQL Server 2000 service pack and place it in a folder on drive C: of the primary node of the cluster.
- Start the setup.bat program to begin the service pack installation process.
- After clicking past the introductory screens, you will be asked to enter the virtual name of your SQL Server 2000 cluster.
- Next, you will be asked to select the appropriate authentication method.
- In the Remote Information dialog box, enter the appropriate login credentials. Generally, this should be the name of the account and the password used for the mssqlserver service.
- After this screen, the service pack installation process begins and updates both nodes of the SQL Server 2000 cluster.
- Reboot the primary node of the cluster and let it restart fully.
- Reboot the secondary node of the cluster and let it restart fully.
At this point, the upgrade is now complete. But before you put the server back into production, there are a few more steps you should perform.
Continues…