how to remove user from Sharepoint 2019 SQL database

SinPeow 86 Reputation points
2021-04-05T09:56:00.353+00:00

add new user to Search service application will create the user account login under SQL security , due to security team request we need to remove the user account from SQL server .
After remove the user permission from Search service application SQL permission is removed but the account still available at SQL server
try to manually delete the account from the root security but notice that under search database still have the user account there (with no permission) and some schema over there.

my question if we just delete the account without clean up the schema will causing SharePoint patching failed in future ?

any better way to clean up all in one short ?
thanks

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,217 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,798 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emily Du-MSFT 41,771 Reputation points Microsoft Vendor
    2021-04-06T09:45:22.957+00:00

    @SinPeow

    I don’t think manually clean up the account (not service account) will cause hidden issues.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Trevor Seward 11,681 Reputation points
    2021-04-05T17:29:28.133+00:00

    Which account are you referring to, specifically? You need to maintain accounts in SQL in order to properly run the service.