在SharePoint 2013 Server服务器场的配置上始终配置SQL [英] Configure SQL always on Configuration for SharePoint 2013 Server Farm

问题描述

SQL数据库故障转移到辅助实例时.我收到如下消息

对于给您带来的任何不便，我们深表歉意，但是我们仅在进行一些改进的同时将网站设为只读.

这只是一个可以忽略的警告，还是我在配置过程中错过了重要的一步.

到目前为止的步骤

已安装SharePoint二进制文件并使用SQL Server配置了SharePoint
• 为SharePoint Always配置为同步模式下配置的SQL别名
• 当第一个主实例上的SQL实例停止时.辅助SQL Server自动成为主要SQL Server，SharePoint成功呈现，但是它具有消息.
• >在SQL中，数据库在主实例和辅助实例上显示为已同步.
• 手动故障转移和使用故障转移向导具有与以下所示相同的效果

我还可以在ulsViewer日志中看到以下严重错误，这表明它是一种只读模式

SharePoint无法在SQL Server实例SQL01上更新数据库.数据库(....)是只读的.下面包括来自SQL Server的其他错误信息. 由于数据库是只读的，因此无法更新SharePoint_Config数据库.

解决方案

Syed，

何时停止了执行备份的第一个实例?

Configured SharePoint 2013 farm with SQL server 2012 AOAG group.

When the SQL database fails over to the secondary instance . I get a message as follows

We apologize for any inconvenience, but we've made the site read only while we're making some improvements.

It seems like it is in read mode.

Is it just a warning that can be ignored or am I missing an important step during configuration.

I have configured the SQL AOAG(Always on Availability group) in Synchronous mode.

Steps so far

• Installed SharePoint binaries and configured SharePoint with SQL server
• Installed SQL on two SQL servers. Configured AOAG group with a Listener
• Configured SQL alias name for SharePoint Always configuration in Synchronous mode
• When the SQL instance on the first primary instance is stopped. The secondary SQL server automatically becomes the primary and SharePoint successfully renders but it has the message.
• In SQL the databases appear as synchronized on the primary and secondary instance.
• Manual fail-over and using fail-over wizard have the same effect as shown below

. See Image below 

I also can see the following critical error in the ulsViewer Logs which implies it is an an read only mode

SharePoint Cannot update database on SQL Server instance SQL01. Database (....) is read/only. Additional error information from SQL Server is included below. Failed to update SharePoint_Config database because the database is read-only.

解决方案

Hi Syed,

When you stopped the first instance where you performing any backup?

这篇关于在SharePoint 2013 Server服务器场的配置上始终配置SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！