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

SQL SERVER - Account Added Automatically in SQL Server Used by SharePoint securityloginicon 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)

, , ,
Previous Post
SQL SERVER – How to Install New Sample Database WideWorldImportersDW.bak
Next Post
SQL SERVER – How to Restart SQL Azure Database?

Related Posts

Leave a Reply

Menu