Link to home
Start Free TrialLog in
Avatar of Tolga Inci
Tolga InciFlag for Türkiye

asked on

How can I remove 20 users SQL Express created?

Hello,

I have Server 2019 Essentials with 25 user limitation. However it's shutting down because SQL Express has created 21 extra users, even though I only have 6 users. I think this is related to Machine Learning and R scripts that I don't need. I think I installed SQL Express Advanced as full which has caused the problem. How can I remove these 21 users? Will uninstalling Machine Learning and R scripts, remove these users and how can I do it? SQL Server version is 2017 14.0.2037. Thank you in advance for your help.

Best Regards,
TolgaUser generated image
Avatar of arnold
arnold
Flag of United States of America image

Check what you setup related to R scripts and how many instances you specified that you the authorized it to create the users.
You can the disable, delete the users that are no longer needed.

Part of the setup you granted SQL rights to execute external scripts.
ASKER CERTIFIED SOLUTION
Avatar of Tolga Inci
Tolga Inci
Flag of Türkiye image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial