patternMinor
Why is SQL Server Express creating twenty users on my system?
Viewed 0 times
whyexpresstwentysqlcreatingsystemserverusers
Problem
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".
Why? Is my system infected?
The descriptions all say, "Local user account for execution of R scripts in SQL Server instance SQLEXPRESS".
Solution
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.
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.
Context
StackExchange Database Administrators Q#190507, answer score: 8
Revisions (0)
No revisions yet.