Is it possible to run an SQL Server Web edition in a Windows 2008 R2 Failover Environment?
I want to host a Website with backend database but keep it failsave with a failover cluster (install it on two nodes and failover if one node fails).
Windows – SQL Server Web Edtion Failover Cluster
failoverfailoverclustersql-server-2008windows
Best Answer
Only Standard and Enterprise editions support clustering, and Standard only 2 nodes at that. Have a look at this matrix: http://msdn.microsoft.com/en-us/library/cc645993(SQL.100).aspx