Hi All
I am hoping you wisdom here can help ...
I have a 3 Node Windows Cluster with a 2 node SQL Cluster built into it. I have SQL Server 2012 Ent installed with Alwayson running. This has been installed on Windows 2012 Server Core and my lovely systems admin has locked them down so tight that I have to write the install scripts with the config file and he runs it. I am not allowed onto my own box... long story there !!!
Any ways I have since found out that he has used the service account the SQL runs under to access a database and change the values of a table...
How can I or can I limit the privileges of the service accounts such that he can not do this with out messing with the rest of the system ?
Hope this helps...
Ford Fairlane
Rock and Roll Detective