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