Microsoft SQL Server

SQL Server Core Engineer Tips

Installation of SQL Server 2008 clusters on Windows 2008 Step 3 : Installation of the first node

Installation of SQL Server 2008 clusters on Windows 2008 Step 3 : Installation of the first node

  • Comments 1
  • Likes


Installation step by step of SQL Server 2008 clustering on Windows 2008
    Step 1 : Validation wizard
    Step 2 : Pre-check
    Step 3 : Installation of the first node
    Step 4 : Add a new node
    Step 5: Apply a service pack or hotfix on a SQL cluster


1. Enter the PID key production for the product SQL Server 2008.
Cluster Failover SQL 2008 
2. On the "License Terms page", select "I accept the License Terms". Click "Next" to continue
Cluster failover SQL 2008 
3. On the "Feature" Selection page, select the components for your installation
SQL Server 2008 Cluster Failover 
Only "Database Engine" and "Analysis Services" are cluster aware. Other components will be installed locally if they are selected.

Warning: Microsoft does not recommend installing the client tools on the cluster nodes. It is best to install on a machine dedicated to the administration of the various instances of the park.

4. On the configuration page, specify if you want a default instance or a named instance.
SQL Server 2008 Cluster Failover 
In "SQL Server Network Name" specify a network name for the new SQL Server failover cluster. This name is the name that will be used to identify your virtual server on the network. Click "Next" to continue.
 
5. On the selection of disks cluster, select the resource shared disk for your SQL Server failover cluster.
SQL Server 2008 Cluster Failover 
The disk cluster will be used to host the SQL Server. Several drives can be specified. The field "Available shared disks" displays a list of available disks, click "Next" to continue.

6. On the Cluster Network Configuration, specify the network resource for your failover cluster instance. Specify the type of IP and the IP address for your failover cluster instance. Click Next to continue.
SQL Server 2008 Cluster Failover 
7. The following image shows the cluster security policies available for Windows Server 2008. In Windows Server 2008 and later, services SIDs (security IDs server) are recommended. For more information about the services functionality SIDs on Windows Server 2008, see Setting Up Windows Service Accounts (http://msdn.microsoft.com/en-us/library/ms143504.aspx ). Click "Next" to continue.
SQL Server 2008 Cluster Failover

8. On the Service Accounts tab, specify the login components for SQL Server services. View accounts previously created SQL SQLAgent 
SQL Server 2008 Cluster Failover
You can set the same account for each SQL Server, or you can configure one account per SQL Server. Microsoft recommends setting up a service account individually for each SQL Server to provide a minimum of privileges for each service. Services and SQL Servers have the minimum permissions to perform their respective tasks. For more information, see Setting Up Windows Service Accounts (http://msdn.microsoft.com/en-us/library/ms143504.aspx ) and SQL Server Configuration - Service Accounts ( http://msdn.microsoft.com/en-us/library/cc281953.aspx ) in SQL Server Books Online

9. Use the "Collation" tab to specify a different collation than the default collation for the Database Engine and Analysis Services. Collation of recommendations depends on the application vendor. In case of error, you will then have to do a Master Rebuild or relocate the clustered instance.
SQL Server 2008 Cluster Failover 
10. Use the "Account Provisioning" tab to specify the following information: "Authentication Mode" - select Windows authentication or Mixed Mode Authentication 'for your instance of SQL Server. If you select Mixed Mode authentication, you must provide a strong password for the group built-in Administrator SQL Server.

For more information, see Database Engine Configuration - Account Provisioning (http://technet.microsoft.com/en-us/library/cc281849.aspx).
SQL Server 2008 Cluster Failover
11. Use the "Data Directories" tab to specify additional directories setup as the default directories, click "Next" 
SQL Server 2008 Cluster Failover
Important: If you specify other directories directories default installation, verify that the installation directories are unique for each instance of SQL Server. None of the directories should be shared with the directory of another instance of SQL Server. The data directories must be accommodated by a disk cluster.

12. Use this tab "FILESTREAM" to enable Filestream on your SQL Server instance.
 SQL Server 2008 Cluster Failover
13. The validation system configuration then performs some rules to validate the configuration of SQL Server components that you specified.
SQL Server Cluster Failover  
14. The page "Ready to Install" displays the setup information about your selection of components. To continue, click Install. During installation, the installation process provides a status to monitor the progress of the installation.
SQL Server 2008 Cluster Failover
15. After installation, the page to finalize the installation provides a link to the logs of the installation.
SQL Server 2008 Cluster Failover
To complete the installation process of SQL Server, click Close.



Previous - Next



Michel Degremont | Microsoft EMEA
Product Support Services Developer - SQL Server Core Engineer |
Comments
  • I always hit an error when I enter the SQL Server Network Name, the error says "the given network name is unusable because there was a failure trying to determine if the network name is valid for use by the clustered sql instance due to the following error: nework address is invalid"

    What do I need to do ?

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment