• Microsoft SQL Server

    Installation of SQL Server 2008 clusters on Windows 2008 Step 4 : Add a new node

    • 0 Comments


    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. Start the installation from the passive node and select "Add node to a SQL Server failover cluster"

    Cluster 2008 add nove
    2. The System Configuration Checker runs a discovery operation on your computer. To continue, click "OK". You can view the details on the screen by clicking "Show Details", or as an HTML report by clicking "View detailed report".
    cluster 2008 add node 

    3. On the License Terms page, read the license agreement, and then select the check box to accept the license terms and conditions. Click Next to continue. Then, on the Setup Support Files page, click Install to install the setup support files.

    Cluster SQL 2008 add node
    4. The System Configuration Checker verifies the system state of your computer before Setup continues. After the check is complete, click Next to continue. You can view the details on the screen by clicking Show Details, or as an HTML report by clicking View detailed report.

    Correct problems that are carryovers from the list of rules. Errors are blocking, but not warnings. A good practice is to correct all errors and warnings.

    5. On the Cluster Node Configuration, using field SQL Server instance name to select the name of the instance of SQL Server 2008 failover cluster that must be added during installation

    Cluster SQL 2008 Add nove
     
    6. The "Service Accounts", specify the account to the SQL Server. Services that are configured on this page are the components you selected during installation. For a clustered installation, account information and the startup type will be informed automatically based elements of the first installation. You need to provide the passwords for each account.
    SQL 2008 cluster failover add nove 

    Security note: Do not use the password blank. Use a strong password.

    7. When you specify the information password for the SQL Server, click Next.

    8. The "Ready to Add Node" appears and shows the installation options that you specified during setup.

    Cluster SQL 2008 add node
     
    9. The Add Node Progress page provides status so you can monitor add node progress as Setup proceeds.
    Cluster failover SQL 2008 add node 

    10. To complete the SQL Server installation process, click Close.

    Cluster failover SQL 2008 add node


     The installation of your cluster 2 nodes is completed :-)


    How to: Add or Remove Nodes in a SQL Server Failover Cluster (Setup)
    http://msdn.microsoft.com/en-us/library/ms191545.aspx




    Previous

    Michel Degremont | Microsoft EMEA
    Product Support Services Developer - SQL Server Core Engineer |
  • Microsoft SQL Server

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

    • 0 Comments


    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 |
  • Microsoft SQL Server

    Installation of SQL Server 2008 clusters on Windows 2008 Step 2 : Pre-check

    • 0 Comments


    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. Pre-check the system to be ready for setup procedure :

     Stop anti-virus
     Perform a failover test by Moving disk resource
      Configure a Windows Firewall for Database Engine Access
     Creating service accounts for SQL and SQL Agent
      The node [NODE1]  is started
      The node [NODE2]  is started
      The shared storage system is started
     A domain controller is available


    2. Prerequisites

    The. NET Framework 3.5 SP1 and Windows Installer 4.5 are required components to install SQL2008. (http://msdn.microsoft.com/en-us/library/ms189910.aspx )

    Installation of SQL Server 2008 clusters on Windows 2008

    Download :
    - Framework 3.5   or from SQL installation's CD inside  /redist/DotNetFrameworks
    - Windows installer 4.5


    3. Setup Support Files : Run setup installation of  SQL server

    click on "New SQL Server Failover Cluster Installation"

    SQL server 2008 cluster failover
    Sur la page du Setup Support Files, cliquez sur "Install" pour installer les support Files.
    SQL server 2008 cluster failover

    3. The System Configuration Checker runs a discovery operation on your computer. To continue, click "OK".  

    SQL Server 2008 cluster failover
     
    You can view the details on the screen by clicking "Show Details", or as an HTML report by clicking "View detailed report".

    SQL server 2008 cluster failover

    SQL Server 2008 cluster failover

    Correct problems that are carryovers from the list of rules. Errors are blocking, but not warnings. A good practice is to correct all errors and warnings.



    Previous - Next

    Michel Degremont | Microsoft EMEA
    Product Support Services Developer - SQL Server Core Engineer |
  • Microsoft SQL Server

    Installation of SQL Server 2008 clusters on Windows 2008 Step 1 : Validation wizard

    • 1 Comments



    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


    Before to  begin I invite you to read my previous article: Installation SQL Server 2005/2008 failover clusters on MSCS Windows 2003/2008


    For your cluster configuration is supported by Microsoft, it's imperative to run the validation wizard. The outcome of this report wizard should indicate that all components are compliant. This report is stored in c:\windows\cluster\report. It must be preserved. Then every time you modify an element constituting the hardware or software configuration of your cluster, it will be necessary to rerun the Validation Wizard.

    1. Run the component by : Start /Administratives tools/ Failover Cluster Management

    Cluster SQL 2008

    2. Then into Failover Cluster Management, clic on  Validate Configuration
    SQL 2008 Cluster


    3. Enter the name of the cluster components nodes
    SQL 2008 Cluster
     

    4. Prior to production, we must run all tests. Then during normal operation, the wizard disables validation tests for hard disks allocated to Services/Application existing.
    SQL 2008 Cluster

    5. Click on next
    SQL 2008 Cluster

    6. Click on next, all elements should be green
    SQL 2008 Cluster



    Next
    Michel Degremont | Microsoft EMEA
    Product Support Services Developer - SQL Server Core Engineer |
Page 1 of 1 (4 items)