We have a SharePoint 2013 farm and when it was created we setup the database server to a single node in a SQL 2012 cluster (ch1) and not to the cluster itself (sql2012). We saw the error and added another database server to the SharePoint farm this time pointing to the SQL cluster.
We now have half the DB’s pointing to the single node and the other half pointing to the cluster.
The problem is when a node on the SQL cluster fails SharePoint is looking for the sql server on ch1 and fails.
The goal is to have all db’s point to sql2012 cluster.
Looking for suggestions
• Detach and reattach?
• Alias the ch1 node?
• hoping there is a powershell script