SP数据访问数据库角色的问题 [英] Issue with SP Data Access DB Role

问题描述

大家好，

SPDataAccess出现权限问题.我已使用mount-spcontentdatabase命令将SP的内容数据库从SP 2010迁移/升级到2013，此功能已成功完成，但是一旦我导航到该站点和其中一个迁移的文档 库，单击文档将导致500错误.我发现的解决方案是将spdataaccess角色放置在db_owner角色中，这解决了该问题，但是我希望能够长期解决该问题，因为sp喜欢更改db权限. 进行psconfig时.

I am having a permissions issue with SPDataAccess. I have migrated/upgraded a content db from SP 2010 to 2013 with the mount-spcontentdatabase command, this function completes successfully, but once i navigate to the site and one of the migrated document libraries, clicking on a document results in a 500 error. The solution I have found is to place the spdataaccess role in the db_owner role, this resolves the issue, but i want to be able to resolve the issue for the long haul, since sp likes to change db permissions when doing a psconfig.

感谢您的时间，

尼克

推荐答案

如果我们希望配置向导正确运行，则设置用户管理员帐户必须可以登录到运行SQL Server的计算机，并且该帐户 您用于运行配置向导的向导必须具有适当的特殊SQL Server角色成员身份，或者必须以db_owner身份访问数据库.

If we want the configuration wizards to run correctly, the setup user administrator account must can log on to the computer running SQL Server, and the account that you use to run the configuration wizards must have the appropriate special SQL Server role membership or access as db_owner on the databases.

附加内容时

When attaching a content database to a web application, the SharePoint farm service account must have db_owner permission for the content database.

https://technet.microsoft. com/en-us/library/cc678863(v = office.15).aspx

这篇关于SP数据访问数据库角色的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！