Can anybody point me to documents that would substantiate the following assertion to my network manager:
"It's standard practice to have your SQL DBA administer the host server as Windows local admin (a VM in this instance)."
My network & servers manager wants me to document why I, the DBA, need to have Local Admin access to the production database and reporting servers. Part of the problem is that I sit with the application team, rather than net & servers.
However, I am an experienced production and development DBA in MS SQL Server (6.5 to 2008 R2) who has performed Windows local admin tasks in the past -- and will need to in the future.
Specifically I think I need local admin privileges in order to deploy and maintain the following:
SQL Agent b/u and maint. jobs; SSRS, SSIS, SSAS, 3rd party ETL (extract-transform-load), Log Shipping from production OLTP server to reporting server. Creation of backup files on local disk. SQL Server and OS performance monitoring. Start
and stop services. Some Active Directory administration (for logins and groups)
Can anybody help me substantiate why I need local admin privileges on the database server -- even though I don't have formal Windows System Admin training, experience tells me I need local admin access in order t
View Complete Post