SQL Server 2016 unable to use internal authentication for maintenance

Copper Contributor

Dear community,

 

after intergration of current security baseline on our 2019 servers i noticed that the SQL Server 2016 is running and useable, but unable to run any maintenance plan. I am able to login with sql server management studio 18.8 and SA account, but when starting the maintenance plan fails instantly and the SA account get locked for at least 10 minutes. I can repeat this behaviour every time. When i remove the secutity baseline settings everything runs without any issue. It is a bit frighten me that i have to check all +4000 Settings to find the cause. May you have a hint for me to find the setting that cause the error? Or maybe anyone had the same issue and know the exact cause?

 

Thank you!

0 Replies