Pre-Installing SQL Database for CommServe - Clustered Environment - Virtual Server

Click on a link below to go to a specific section of the software installation:

Overview
The following procedures describes the steps for pre-installing the Microsoft SQL Server Enterprise Edition in a clustered environment as well as the appropriate service pack.

In a clustered environment, Microsoft SQL Server 2005 (Enterprise Edition) with the appropriate service pack must be installed and clustered prior to installing the CommServe software. The CommServe software automatically uses the default or the named instance created during the SQL installation.

Before You Begin
  • Log on to the computer as local Administrator or as a member of the Administrators group on that computer.
  • Verify that the latest Operating System service packs are installed on all nodes in the cluster group.
  • Make sure that you have the appropriate Software Installation Disc for the operating system in which you wish to perform the install.
  • The cluster should be functional, and the cluster group to which you want to install Microsoft SQL Server should be configured with a disk resource. You should review http://technet.microsoft.com/en-us/library/ms189910.aspx for the full set of prerequisites to installing Microsoft SQL Server on a cluster.
  • SQL Server cannot be installed on a Cluster Quorum disk.
  • Ensure that the Microsoft Distributed Transaction Coordinator (MSDTC) is installed and running on the cluster.
  • Ensure that cryptographic services and Task Scheduler are running on all physical nodes.
  • Ensure that you are not logged into both of the cluster nodes, or SQL may fail to run the install on the other node. See http://support.microsoft.com/kb/910851 for more information.
  • You will need to add a Group in Active Directory, and add a user to that group which will have full access to both nodes of the cluster. See http://technet.microsoft.com/en-us/library/ms345196.aspx for more information on the Microsoft SQL Server Group. This account could be the same account that the cluster services run under, but must be added to a Group.

  • Before upgrading the SQL Server, install the .NET Framework package from the Software Installation Discs. The package is available in the appropriate folder for each platform as follows:

    32-bit:  INTEL32\Bin\DotNetFramework\2.0\dotnetfx.exe

    X64:     AMD64\Bin\DotNetFramework\2.0\NetFx64.exe

  • For more information regarding this installation procedure, refer to Microsoft's How To: Create a New SQL Server 2005 Failover Cluster (Setup).

Install Procedure

Installing SQL Server and creating the instance
1. From the appropriate software installation disc run the following program:

SQL2005\SQL_Enterprise_Edition\Servers\setup.exe

  
2. Click I accept the licensing terms and conditions and then click Next to continue.  
3. Click Install to continue.
4. Click Next to continue.
5. Click Next to continue.
6. Click Next to continue.
7. Enter Name and Company information and then click Next to continue.
8. Select SQL Server Database Services and Create a SQL Server failover cluster.

Click Advanced for more options.

 
9. Expand Client Components, right-click on Management Tools, and select Install.

Click Next to continue.

 
10. Perform the following and then click Next to continue.
  • Click the Named Instance option.
  • Enter instance name, e.g., BullCalypso.

Click Next to continue.
11. Enter the name of the Virtual Server.

NOTES

The name of the Virtual Server is the SQL Network Name in cluster administration.

Click Next to continue.
12. Select the Network to use from the drop-down list, and enter a new IP address to use for the cluster group. This IP address will map to the Virtual Server chosen in the previous step.

Click Add to enter all the necessary IP addresses for the interfaces in the cluster group.

NOTES

The Cluster Heartbeat does not need to be added to the SQL cluster group.

Click Next to continue.

13. Select the Cluster Group to which the Virtual Server Resources will be installed, and enter the location for the SQL files in the Data files field.

Click Next to continue.

14. Select the nodes to include in the Virtual Server.

NOTES

If any nodes are listed as Unavailable Nodes, verify that the System Configuration Check did not list any errors. Verify that all prerequisites have been met.

Click Next to continue.

15. Enter the password for the user account that is being used for the current cluster node so that when SQL runs the remote install on the other node, it can login seamlessly.

Click Next to continue.

16. Perform the following and then click Next to continue.
  • Click the Use a domain user account option.
  • Enter a valid username, password and domain name in the Username, Password and Domain boxes.

NOTES

This account must have access to all the nodes in the cluster group.

Click Next to continue.

17. Enter the name of the group of that was created for the external domain in Before You Begin.  

Click Next to continue.

18. Perform the following and then click Next to continue.
  • Choose the Mixed Mode (Windows authentication and SQL Serve authentication) option.
  • Enter and confirm the password in the Enter Password and Confirm password boxes.
19. Perform the following and then click Next to continue.
  • Choose the SQL Collations (Used for compatibility with previous versions of SQL Server) option.
  • Click Dictionary order, case-insensitive, for use with 1252 Character set in the SQL Collations list.

NOTES

  • Selecting Dictionary order, case-insensitive, for use with 1252 Character set option will set the SQL Collation setting for the databases as SQL_Latin1_General_CP1_CI_AS.
20. Select the options best suited for your environment.

Click Next to continue.
21. Click Install to continue.
22. Click Next to continue.
23. Click Finish to exit.

Installing SQL Server Service Pack
24. From the appropriate software installation disc run the following program:

SQL2005\SP2\SQLServer2005SP2-KB921896-x86-ENU

  
25. Click Next to continue.
26. Click I accept the agreement and then click Next to continue.
27. Select the Error and Usage Reporting Settings and click Next to continue.
28. Select the features to update and click Next to continue.
29. Choose Windows Authentication option and then click Next to continue.
30. Click Install to continue.
31. Click Next to continue.
32. Install summary is displayed. Click Next to continue.
33. Click Finish to exit.