SQL SERVER – Account Added Automatically in SQL Server Used by SharePoint

Earlier I wrote a blog about DBA doing detective work. SQL SERVER – Why We have Audit Trace in DATA Folder? What are These Files? . Now today there is another similar situation where account is added automatically in SQL Server used by SharePoint.

I was thrown into the same situation by a recent interaction with customers. They informed that there is a user account that gets re-added to security roles. The main issue which they reported was that the account which was getting added was for a user who left the company. Here are the database names where it was getting added:

SharedServices_Search_SSPDB, SharedServices_SSPDB, SharePoint_Config

I captured a profile to find how its getting added. I found that this was being done by SharePoint service at scheduled time. I checked the internet and couldn’t find anything. Most likely, this user has used his own account as a setup account and used to configure SharePoint Shared Service Provider (SSP).

WORKAROUND/SOLUTION

I am not sure if there is a way to resolve the automatic account addition. I learned that a user should not use personal accounts for SharePoint setup. The only feasible option which I offered them to disable the account in active directory level, so it cannot be used by a user.

Reference: Pinal Dave ( https://blog.sqlauthority.com )

Journey to SQLAuthority稿源:Journey to SQLAuthority (源链) | 关于 | 阅读提示

本站遵循[CC BY-NC-SA 4.0]。如您有版权、意见投诉等问题,请通过eMail联系我们处理。
酷辣虫 » 后端存储 » SQL SERVER – Account Added Automatically in SQL Server Used by SharePoint

喜欢 (0)or分享给?

专业 x 专注 x 聚合 x 分享 CC BY-NC-SA 4.0

使用声明 | 英豪名录