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

存储架构 2017-12-30

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

责编内容by:Journey to SQLAuthority (源链)。感谢您的支持!

您可能感兴趣的

Oracle的CLOB大数据字段类型 一、Oracle中的varchar2类型 我们在Oracle数据库存储的字符数据一般是用VARCHAR2。VARCHAR2既分PL/SQL Data Types中的变量类型,也分Or...
Statistical Calculations Statistical calculations in SQL Server Does anyone know of any ...
C # sqldataadapter datatablemapping I have a query - " SELECT PK1 FROM users "; I also have a datatable named myTable with t...
MySQL Error Based SQL Injection (报错注入)总结... 点击阅读全文 MySQL报错注入 利用数据库报错来显示数据的注入方式经常会在入侵中利用到,这种方法有一点局限性,需要页面有错误回显。 数据类型转换报错是最常见的一种方法,在微软SQ...
Remove relational index options when the index of ... Using the Microsoft.SqlServer.Management.Smo.Scripter object, I'm generating scripts for each of the...