SQL Server Failover with Sharepoint
Posted on 2010-09-07
Hi, I am currently trying to set up a high availability environment with Sharepoint using a SQL Server 2008 database.
Right now I have two servers:
A: Sharepoint 2007, Project Server 2007, SQL Server 2008
B: Sharepoint 2007, Project Server 2007
Server B essentially acts as a replica web front-end of Server A.
I am interested in adding a SQL Server Failover Cluster Installation to Server B. When I go to try to install it, I get a number of errors stating: "The local computer is not a member of a Windows failover cluster".
So I assume I'd go to Windows Server Manager under "features" and add "Failover Clustering". I have never created a Windows failover cluster before so I am unfamiliar with how this works.
--Am I going about this the right way?
--Instead of adding the SQL Server failover feature to Server B, should I create a Server C instead?
--Do I need to add the Windows Failover Clustering to Server A since the database is located here to take advantage of this feature? Is this going to break my front end if I add clustering at this point?