May 20, 2021 at 8:05 am
Good morning all ,
Does the fact that the Active directory account for starting the SQL service is locked does this cause problems with the functioning of SQL server
thanks
May 20, 2021 at 5:41 pm
Kind of. Anything that needs to authenticate as that account will fail. Anything that has previously authenticated will work fine. SO, the SQL instance will continue to run without problems, but your SQL Agent jobs will fail for example.
I also expect anything that reads or writes to disk directly (not to the database, but something like a backup or a restore or xp_cmdshell, probably SSRS/SSIS and polybase, likely R and Python) would have issues.
Anything that needs to spawn a new process (such as a SQL Agent Job) would very likely fail to start.
IF any of the services needed a restart, they would fail to start as well.
BUT users logging into a SQL Server instance and running SELECT, INSERT, UPDATE, or DELETE queries should have no problems.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply