SharePoint 2013-SessionStateService DB无法在镜像设置中进行故障转移 [英] SharePoint 2013 - SessionStateService DB not failing over in mirror setup

问题描述

你好

我们一直在SharePoint 2013环境中进行一些灾难恢复测试，但是当尝试将数据库从主镜像故障转移到辅助镜像时，SharePoint开始出错.

We've been doing some DR testing on our SharePoint 2013 environment but when trying to failover our DBs from the primary to secondary mirror SharePoint starts to error.

每次查看ULS日志时，都会看到以下内容:

Looking in the ULS logs we're seeing this each time:

System.Data.SqlClient.SqlException:无法打开数据库"SessionStateService_< GUID>"；登录要求.登录失败.用户'< DOMAIN> \< SharePoint_Application_Pool_Account>'

System.Data.SqlClient.SqlException: Cannot open database "SessionStateService_<GUID>" requested by the login. The login failed.  Login failed for user '<DOMAIN>\<SharePoint_Application_Pool_Account>'

查看两台服务器上的权限，我们可以看到SharePoint应用程序池帐户是SessionStateService数据库上的数据库所有者，因此我们不确定为什么要这样说.

Looking at the permissions on both servers we can see that the SharePoint Application Pool account is a DB owner on the SessionStateService database so we're not sure why it's saying this.

有人有什么想法吗?

谢谢
詹姆斯

Thanks
James

推荐答案

詹姆斯，

要解决此问题，您可以检查以下内容:

To troubleshoot the issue, you could check things below:

1.检查SharePoint应用程序池帐户是否具有登录SQL Server的权限.

1. Check if the SharePoint Application Pool account has the permission to login the SQL server.

2.检查SharePoint应用程序池帐户是否具有登录数据库"SessionStateService_< GUID>"的权限.

2. Check if the SharePoint Application Pool account has the permission to login the database "SessionStateService_<GUID>".

最诚挚的问候，

萨拉范

这篇关于SharePoint 2013-SessionStateService DB无法在镜像设置中进行故障转移的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！