无法更改角色'db_owner'，因为它不存在或您没有权限... [在SPSubscriptionSettingsDatabase] [英] Cannot alter the role 'db_owner', because it does not exist or you do not have permission...[on the SPSubscriptionSettingsDatabase]
问题描述
将SharePoint 2013 On-Prem场从2017年6月CU级升级到2018年1月CU级后，我在第一次运行配置向导的第9步中遇到以下异常：
After upgrading a SharePoint 2013 On-Prem farm from June 2017 CU level to the January 2018 CU level, I encountered the following exception(s) on step 9 of 10 of the first run of the Configuration Wizard:
配置失败
一个或多个配置任务失败。 。 。
无法升级SharePoint产品。
这是一项关键任务。您必须先修复故障才能继续。请按照此链接获取有关如何解决升级失败问题的详细信息：... Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException类型的异常抛出
。 其他异常信息：
运行SQL DDL脚本时出错： IF  EXISTS（从sys.database_principals中选择TOP 1 1 WHERE name = N'db_owner'A .... System.Data.SqlClient.SqlException（0x80131904）：
无法更改角色'db_owner'，因为它不存在或者你没有permission.Cannot改变角色"的db_owner"，因为它不存在，或者你没有permission.ClientConnectionId：7454882a-1aa0-43bc-bc05-84e79ec5d989Error编号：15151，状态：1，等级：16        
（事件ID：al2pi）
升级[SPSubscriptionSettingsDatabase名称= SPI_Prod_SubscriptionSetting ...]失败    群组。 ; （EventID：ajxnm）
例外：无法更改角色'db_owner'，因为它不存在或您没有权限。无法更改角色'db_owner'，因为它不存在或您没有权限。 （EventID：ajxnm）
（EventID：ajxnm）
升级计时器作业由于异常而退出：System.Da ta.SqlClient.SqlException（0x80131904）：无法更改角色'db_owner'，因为它不存在或您没有权限。无法更改角色'db_owner'，因为它不存在或者您没有
有权限。
Configuration Failed
One or more configuration tasks failed. . .
Failed to upgrade SharePoint Products.
This is a critical task. You have to fix the failures before you can continue. Follow this link for more information about how to troubleshoot upgrade failures: ... An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException
was thrown. Additional exception information:
Error running SQL DDL Script: IF EXISTS (SELECT TOP 1 1 FROM sys.database_principals WHERE name = N'db_owner' A.... System.Data.SqlClient.SqlException (0x80131904):
Cannot alter the role 'db_owner', because it does not exist or you do not have permission.Cannot alter the role 'db_owner', because it does not exist or you do not have permission.ClientConnectionId:7454882a-1aa0-43bc-bc05-84e79ec5d989Error Number:15151,State:1,Class:16
(EventID:al2pi)
Upgrade [SPSubscriptionSettingsDatabase Name=SPI_Prod_SubscriptionSetting...] failed. (EventID:ajxnm)
Exception: Cannot alter the role 'db_owner', because it does not exist or you do not have permission.Cannot alter the role 'db_owner', because it does not exist or you do not have permission. (EventID:ajxnm)
(EventID:ajxnm)
Upgrade Timer job is exiting due to exception: System.Data.SqlClient.SqlException (0x80131904): Cannot alter the role 'db_owner', because it does not exist or you do not have permission.Cannot alter the role 'db_owner', because it does not exist or you do not
have permission.
Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException：类型Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException'被抛出的异常
Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException: Exception of type 'Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException' was thrown.
at Microsoft.SharePoint.PostSetupConfiguration.UpgradeTask.Run（）
at Microsoft.SharePoint.PostSetupConfiguration.UpgradeTask.Run()
at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask（）
at Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()
运行[PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures]失败，在第5任务中遇到相同的异常：
Running [PSConfig.exe -cmd upgrade -inplace b2b -force -cmd applicationcontent -install -cmd installfeatures] failed with the same exception(s) at task 5 of 6:
服务器场正在定时服务进程中升级。任务完成14.71％。
无法升级SharePoint产品。
抛出类型Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException的异常。 其他异常信息：升级命令无效或遇到故障。
运行SQL DDL脚本时出错： IF  EXISTS（SELECT TOP 11 FROM sys.database_principals其中name = N'db_owner" A .... System.Data.SqlClient.SqlException（0x80131904）：无法改变的角色 '的db_owner'，因为它不存在或您没有权限。不能
al角色'db_owner'，因为它不存在或者您没有权限。无法更改角色'db_owner'，因为它不存在或您没有权限。无法更改角色'db_owner'，因为它确实不存在，或者你没有permission.ClientConnectionId：5395f82b-1016-4eb6-a18c-a11e7958406cError
编号：15151，状态：1，等级：16（事件ID：al2pi）
升级[ SPSubscriptionSettingsDatabase Name = SPI_Prod_SubscriptionSetting ...]失败。 （EventID：ajxnm）
异常：无法更改角色'db_owner'，因为它不存在或您没有权限。无法更改角色'db_owner'，因为它不存在或者您没有权限。无法更改角色'db_owner'，因为它不存在或者您
没有权限。无法更改角色'db_owner'，因为它不存在或您没有权限。 ;    （EventID：ajxnm）（EventID：ajxnm）
由于异常，升级计时器作业正在退出：System.Data.SqlClient.SqlException（0x80131904）：无法更改角色'db_owner'，因为它没有存在或您没有权限。无法更改角色'db_owner'，因为它不存在或者您没有
有权限。无法更改角色'db_owner'，因为它不存在或您不存在有权限。不能改变角色'db_owner'，因为它不存在或你没有权限。
The farm is being upgraded in the timer service process. The task is 14.71% completed.
Failed to upgrade SharePoint Products.
An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown. Additional exception information: The upgrade command is invalid or a failure has been encountered.
Error running SQL DDL Script: IF EXISTS (SELECT TOP 1 1 FROM sys.database_principals WHERE name = N'db_owner' A.... System.Data.SqlClient.SqlException (0x80131904): Cannot alter the role 'db_owner', because it does not exist or you do not have permission.Cannot
alter the role 'db_owner', because it does not exist or you do not have permission.Cannot alter the role 'db_owner', because it does not exist or you do not have permission.Cannot alter the role 'db_owner', because it does not exist or you do not have permission.ClientConnectionId:5395f82b-1016-4eb6-a18c-a11e7958406cError
Number:15151,State:1,Class:16 (EventID:al2pi)
Upgrade [SPSubscriptionSettingsDatabase Name=SPI_Prod_SubscriptionSetting...] failed. (EventID:ajxnm)
Exception: Cannot alter the role 'db_owner', because it does not exist or you do not have permission.Cannot alter the role 'db_owner', because it does not exist or you do not have permission.Cannot alter the role 'db_owner', because it does not exist or you
do not have permission.Cannot alter the role 'db_owner', because it does not exist or you do not have permission. (EventID:ajxnm)(EventID:ajxnm)
Upgrade Timer job is exiting due to exception: System.Data.SqlClient.SqlException (0x80131904): Cannot alter the role 'db_owner', because it does not exist or you do not have permission.Cannot alter the role 'db_owner', because it does not exist or you do not
have permission.Cannot alter the role 'db_owner', because it does not exist or you do not have permission.Cannot alter the role 'db_owner',because it does not exist or you do not have permission.
研究提出了一些可能性。
Research suggested a few possibilities.
一些论坛帖子显示，遇到此类错误的人可以通过打开SQL Management Studio，深入到订阅设置服务数据库> 钻取到安全性中来解决这个问题。该数据库的文件夹> 钻取
进一步向 用户>查找并右键单击您用于在用户列表中运行ConfigWiz的帐户>属性>拥有的架构>选择"db_owner"然后单击"确定"。 但这对我没有帮助。每次运行psconfigUI.exe或psconfig.exe时，我都会多次执行
并遇到完全相同的异常。此外，每次运行configwiz时，我添加的权限都被删除了。
Some forum posts showed some people who encountered this type of error could get past it by opening SQL Management Studio, drilling down to the subscription settings service database > drilling into the security folder of that database > drilling further down to Users > finding and right-clicking the account that you're using to run the ConfigWiz in the list of users > Properties > Owned Schemas > select "db_owner" and click OK. But that didn't help me. I did it several times and ran into the exact same exceptions every time I ran psconfigUI.exe or psconfig.exe. Also, the permissions I added were stripped away every time I ran configwiz.
我发现的两个论坛帖子建议这与SQL永远在线和/或可用性组有关。我从AO AG中删除了订阅数据库，这也没有帮助。相同的例外。但我没有像完全建议的那样将它从完全恢复模式设置为简单的
恢复模式。 所以也许我对此并不够了。
Two forum posts I found suggested this was related to SQL Always-On and/or Availability-Groups. I removed the subscription database from the AO AG and that didn't help either. Same exceptions. But I did not set it from full recovery mode to simple recovery mode like some suggested. So maybe I didn't go far enough with this.
推荐答案
我的方式解决这个问题是运行以下命令来手动升级订阅设置数据库：
The way I got around this was to run the following command to manually upgrade the Subscription Settings database:
（Get-SPDatabase |？{
(Get-SPDatabase | ?{
_.type -eq"Microsoft SharePoint Foundation订阅设置数据库"}）。配置（）
_.type -eq "Microsoft SharePoint Foundation Subscription Settings Database"}).Provision()
运行此命令后，我确实遇到了确切的问题。在下一个psconfig / psconfigUI运行期间出现相同的异常，但它使其超过了Subscriptions数据库并且在另一个服务应用程序数据库上失败。 我通过运行
来超越那个：
After running this command, I did run into the exact same exceptions during the next psconfig/psconfigUI run, but it made it past the Subscriptions database and was failing on a different service application database. I got past that one by running this:
（Get-SPDatabase |？{
(Get-SPDatabase | ?{
_。type -eq" Microsoft .SharePoint.BusinessData.SharedService.BdcServiceDatabase"}）。Provision（）
_.type -eq "Microsoft.SharePoint.BusinessData.SharedService.BdcServiceDatabase"}).Provision()
（Get-SPDatabase |？{
(Get-SPDatabase | ?{
这篇关于无法更改角色'db_owner'，因为它不存在或您没有权限... [在SPSubscriptionSettingsDatabase]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
