Our database server (Microsoft SQL Server 2008 R2) undergoes audit and they are requesting to set the value
Security\BuiltinAdminAreServerAdmins to false from default value of true
Now, since it is a production server, my worry is the effect of taking this action, can anyone tell me the effect when I set it to false?
These are the steps to go on said item.
Open the SQL server management studio
Connect to the "Microsoft Analysis Server"
Right click on the "Microsoft Analysis Server" then select properties
Tick the box for "Show Advanced (All) Properties"
Scroll down till you find [Security \ BuiltinAdminsAreServerAdmins] and check the current value.
If the value set to true then stand on the true and change it to false.
Thank you in advance. Please use the following image as a reference.