Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I was taking a look into Computer Management->Users and found that SQL Server Express has created a lot of users for me.
Why? Is my system infected?
The descriptions all say, "Local user account for execution of R scripts in SQL Server instance SQLEXPRESS".
Do you have installed the R- and Machine Learning services? According to the documentation below those are generated to run external scripts of those services in an isolated environment. So I would say they are normal if you install those components.
Those are part of the Advanced Services Variant of the SQL Express Edition.
From the documentation: Modify the user account pool for SQL Server machine learning
By default, the user account pool contains 20 user accounts. In most cases, 20 is more than adequate to support machine learning tasks, but you can change the number of accounts.
- In a default instance, the individual accounts are named MSSQLSERVER01 through MSSQLSERVER20.
- For a named instance, the individual accounts are named after the instance name: for example, MyInstanceName01 through MyInstanceName20.
Open Windows Security log and filter it for Event ID 4720: A user account was created.
You'll found who, when and with what attributes has created these users.
<All Event IDs>.
Nov 9, 2017 at 8:46