In Simple Way

Step by Step Clustering SQL Server 2008 R2 Part VI

Part I – Before we start
Part II – Creating Windows Cluster
Part III – Clustering MSDTC
Part IV – Installing the first SQL Server Cluster Node
Part V – Adding the second node
Part VI – Post installation tasks

On this last part we will only demonstrate how to enable Filestream feature on SQL Server 2008 clustered configuration.
on future posts we will discuss other administrative tasks and tips.
Note : All actions described on these part should be performed on each node.

1	Start the SQL Server Configuration Manager

2	Click Yes on the User Account Control

3	Open the properties windows of the SQL Server Service by right clicking on it and then the Properties context menu

4	Check Enable FILESTREAM for Transact-SQL access and Enable FILESTREAM for file I/O streaming access Type the Windows Share Name to use and then click Apply

5	Verify that a File Share Resource with the same Share Name as configured on the FILESTREAM tab appears and it’s online on the Failover Cluster Manager, the resource should appear as depending on the SQL Server service

6	Run the SQL Script : EXEC sp_configure filestream_access_level , 2 reconfigure

Step By Step Clustering SQL Server 2008 R2 Part V

1	Run the setup program of SQL Server 2008 R2

2	Click Yes on the User Account Control

3	Select the Installation Page on the SQL Server Installation Center and then click Add node to a SQL Server Failover cluster

4	Click Ok after verifying that all Tests are passed on the Setup Support Rules page

5	Type your Product Key and then click Next

6	Check I accept the license terms and then click Next

7	Click Install on the Setup Support Files page

8	Verify that all the Tests are passed on the Setup Support Rules and then click Next For the Network Binding order warning ensure that the Network configuration is correct as described on the first part of this Post

9	The setup program will detect automatically the clustered instances on your configuration and from the Cluster Node Configuration Page you will be able to choose to which SQL cluster you would like to add this node Choose the instance id and then click Next

10	On the service Accounts Page retype the password for each account and the click Next

11	Click Next on the Error Reporting Page

12	Click Next on the Add Node Rules

13	Click Install on the Ready to Add Node Page

14	Wait for the installation Progress

15	Click Close on the Complete Page Now you have a full functional two nodes cluster of SQL Server 2008 R2

Step by Step Clustering SQL Server 2008 R2 Part IV

1	Using the CLSSetup account that have the privileges to join computers to domain and configured as Local Administrator on each node open a session and run the setup program of SQL Server 2008 R2

2	Click Yes on the User Access Control message if it’s appear

3	Select the Installation page and then click New SQL Server failover cluster installation

4	on the Setup Support Rules verify that all tests are passed and then click Ok

5	Type you Product Key and then click Next

6	Check I accept the license terms Click Next

7	On the Setup Support Files click Install

8	When Support files are installed a new rules check will be processed by the setup program ensure that all tests are passed and then click Next

9	Select the features that will be installed and the click Next. Note : SSRS is not cluster aware

10	On the Instance Configuration page type the Network Name that will be used for your Clustered SQL Server Instance , type an instance ID if you won’t use the default name MSSQLSERVER and then click Next

11	Click Next on the Disk Space Requirements Page

12

13	Select the Shared Disks that will depend on your SAL Server Cluster Group and then click Next

14	Type the virtual IP Address that will be used for your SQL Server Cluster Click Next

15	Click Next on the Cluster Security Group page

16	Type the account names and their passwords for the services accounts that will be used

17	Click on the Collation tab if you want to change the default collation of the server by clicking the Customize button Click Next

18	On the Database Engine Configuration Page choose your Authentication Mode, type the password for the sa account if you choose Mixed Mode. Add the AD users or groups that will have the sysadmin role.

19	Click Data Directories Tab and then configure the different drive for each kind of data that will be host on the nodes and then click Next

20	Click Next on the Error Reporting Page

21	Click Next on the Cluster Installation Rules

22	Click Install on the Ready to Install Page

23	Wait for the Installation progress

24	Click Close on the Complete Page

25	From the Failover Cluster Manager verify that all resources was created and are Online on the first node

Step By Step Clustering SQL Server 2008 R2 Part III

Part I – Before we start
Part II – Creating Windows Cluster
Part III – Clustering MSDTC
Part IV – Installing the first SQL Server Cluster Node
Part V – Adding the second node
Part VI – Post installation tasks

The Microsoft Distributed Transaction Coordinator must be clustered for Microsoft support of your SQL Server cluster configuration; You should have MSDTC on your SQL Server cluster if you plan using one of those features :

SSIS
Workstation Components
Distributed transactions

1	On the right pan click Configure a Service or Application from the Actions section

2	Click Next on the Before You Begin Page

3	Select Distributed Transaction Coordinator (DTC) from the service or application list and then click Next

4	On the Client Access Point type the Network name of the MSDTC name and type it’s Virtual IP address and then click Next

5	Select the shared disk that will be used for the MSDTC and then click Next

6

7	Click Finish on the Summary page