Excel Services帐户无法访问使用Powershell创建的Content DB [英] Excel Services account losing access to Content DB created using powershell
问题描述
我遇到一个奇怪的问题.我们使用以下提到的命令在SP 2013服务器场上创建了一个新的网站集.
I am getting a weird issue. We created a new site collection on our SP 2013 farm using the below mentioned commands.
要创建新的内容数据库-
To create a new content DB -
New-SPContentDatabase<内容数据库名称> -DatabaseServer<数据库服务器名称> -WebApplication< https://server>
New-SPContentDatabase <Content DB Name> -DatabaseServer <Database Server Name> -WebApplication <https://server>
要在此新创建的Web应用程序中创建网站集-
To create the site collection in this newly created web app -
New-SPSite –Url<网站集网址> –ContentDatabase<内容数据库名称> -名称<网站集名称> -模板"STS#0&"； -OwnerAlias<域\用户名> –OwnerEmail< email>
New-SPSite –Url <site collection url> –ContentDatabase <Content DB Name> -Name <Name of site collection> -Template "STS#0" -OwnerAlias <domain\username> –OwnerEmail <email>
该网站集已成功创建，并且除一件事情外，一切正常.在服务器场上运行excel服务的服务帐户无权访问此内容数据库，因此无法访问excel文件.我们解决了这个问题 授予服务帐户适当的访问权限后出现问题.
The site collection was created successfully and it seemed to be working all fine except one thing. The service account which runs the excel services on the farm did not have access to this content db and hence excel files were not accessible. We fixed this issue after giving the service account proper access.
但是我想知道为什么会这样，所以当我必须创建另一个网站集时，不必手动授予对服务帐户的访问权限.请检查上面提到的我的powershell命令，让我知道是否可以对其进行任何更改 下次再没有这个问题.
But I want to know why this is happening so that when I have to create another site collection I dont have to manually give access to the service account. Kindly check my powershell commands mentioned above and let me know if I can make any changes on it to not have this issue the next time.
谢谢
Sangeet
推荐答案
您好，Sangeet，
Hi Sangeet,
默认情况下，excel服务帐户没有新内容数据库的权限.
By default, the excel service account does not have the permission on the new content database.
您可以将excel服务帐户添加到服务器场服务帐户中.因为服务器场服务帐户具有所有SharePoint数据库的db_owner.
You could add the excel service account into the farm service accounts. Because the farm service accounts have the db_owner for all SharePoint databases.
然后excel服务帐户将具有所有SharePoint数据库的db_owner.
Then the excel service account will have the db_owner for all SharePoint databases.
然后，当您创建内容数据库时，excel服务帐户将自动成为内容数据库的dbo.
Then when you create the content database, the excel service account will be the dbo of the content database automatically.
要将excel服务帐户添加到服务器场服务帐户，请转到管理中心->安全->配置托管帐户->注册托管帐户.
To add the excel service account to the farm service account, go to central administration->security->configure managed accounts->register managed account.
然后转到配置服务帐户->选择服务器场帐户并选择excel服务帐户，然后单击确定.
Then go to configure service accounts->select farm account and select the excel service account and click OK.
更多参考文献:
在SharePoint 2013管理中心中配置托管帐户.
Configure Managed Accounts In SharePoint 2013 Central Administration.
SharePoint 2013中的帐户权限和安全设置.
Account permissions and security settings in SharePoint 2013.
https://technet.microsoft.com/en-us/库/mt842674(v=office.16).aspx
最诚挚的问候，
萨拉范
这篇关于Excel Services帐户无法访问使用Powershell创建的Content DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
