Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What role do you need to install security updates? Expand / Collapse
Author
Message
Posted Tuesday, December 10, 2013 8:43 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, October 8, 2015 7:53 AM
Points: 48, Visits: 160
Supposed I am using an account in the BUILT-IN\Administrators group. That account has no explicit role defined in SQL Server.

If I want to give that account enough privilege to install security updates, do I need to give that account sysadmin role as well?
Post #1521559
Posted Tuesday, December 10, 2013 9:35 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, June 15, 2016 1:56 PM
Points: 607, Visits: 966
Check out this document:http://technet.microsoft.com/en-us/library/dd638062(v=sql.100).aspx
but this is the quote you are looking for:
SQL Server 2008 updates must be installed under an account that has administrative privileges on the computer where they will be installed.




Microsoft Certified Master - SQL Server 2008
Follow me on twitter: @keith_tate

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1521576
Posted Tuesday, December 10, 2013 4:02 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, June 15, 2016 12:00 PM
Points: 882, Visits: 849
To clarify what Keith is saying: to install security updates, you don't need any permissions in SQL Server at all, only in Windows.

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1521706
Posted Monday, December 16, 2013 4:25 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 2:30 AM
Points: 3,028, Visits: 3,687
If you start talking about SQL Server Service Packs, Cumulative Updates and Hotfixes, then you need authorities in both Windows and SQL Server. This also applies to Security Updates that affect SQL Server - fortunately on average we only get one of these each year as most Security Updates do not affect SQL Server.

However, most sites will apply SQL Server updates separately to Windows updates and often use a different account for each type of update. It is considered best practice to run these types of update separately.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005. 11 May 2016: now over 37,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Quote: "When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist." - Archbishop Hélder Câmara
Post #1523150
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse