I was recently poking around our SQL Server (2014), and noticed the SQL Service account uses the
LOCAL SYSTEM
account. Are there any issues with using this account - Pros/Cons? Should we be using another account?
Users do often execute OPENROWSET
and XP_CMDSHELL
commands. Not sure if that if lower-permissioned accounts work with advanced functions.
Thanks!

Asked by Depth of Field
(233 rep)
Jan 11, 2021, 05:37 PM
Last activity: Jan 11, 2021, 10:49 PM
Last activity: Jan 11, 2021, 10:49 PM