Part II – Creating Windows Cluster
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 |
 |
0 commentaires
Post a Comment