Pau Lo
asked on
local administrator sysadmin role
If you have MSSQL on say a windows 2008 server, if a local administrator (OS) is not currently a sysadmin in MSSQL, just by being local admin on the server, can they make themselves sysadmin? Or if not what permissions do they need to make them sysadmin?
MS recommend not having builtin\admins as part of the sysadmin role, but if they could just grant themselves that permission it seems a waste of time investigating and removing local admins from that role in MSSQL
MS recommend not having builtin\admins as part of the sysadmin role, but if they could just grant themselves that permission it seems a waste of time investigating and removing local admins from that role in MSSQL
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Scott Pletcher
A Windows admin on that box can stop the SQL service, restart it in single user mode, add a sysadmin login of their choosing, stop SQL and restart it normally. Based on the discussions of this I've seen, there's no real way to prevent it even in SQL 2008 (don't know about for SQL 2012).