Home
Topics
Microsoft SQL Server Administration
SQL Server Security
Limit SQL Server admin permissions for domain accounts

Limit SQL Server admin permissions for domain accounts

Denny Cherry, Contributor

What is the best practice for using domain accounts such as those with domain admin permissions for SQL Server service accounts?

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

The SQL Server should never be run under an account with domain admin permissions. Always grant the Windows account that the SQL Server runs under the minimal rights it needs in order to function. The lowest set of permissions that Microsoft SQL Server needs to run are the "Log on as a service," "Log on as a batch job," and if running Enterprise Edition the "Lock pages in memory" rights.

Many people will give the SQL Server local administrative rights to the server. The SQL Server account should never be given domain admin rights as this poses an unacceptable security risk to the Windows domain.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary

This was first published in August 2007

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Wixom: BI applications need visual appeal
  
  Business intelligence teams should upgrade their visual design skills to create winning applications for BI users, says IT professor Barbara Wixom.
- Business intelligence program needs long-term tending to fully blossom
  
  The evolution of Quicken Loans' business intelligence strategy from static reporting to self-service BI holds useful lessons for other organizations.
- O'Reilly Strata conference tackles big topics in data science, Hadoop
  
  The O'Reilly Strata conference was the place to be to learn about the role of the data scientist and big data technologies.
Data Center
- Is energy-efficient software the next step to reduce operating costs?
  
  When the limits of hardware innovation have been reached, energy-efficient software could be way to cut electricity costs.
- Q&A;: Markley looks to lighten load as an IaaS provider
  
  Interest in cloud continues to gain traction, so how does a small infrastructure services provider compete with the Amazon Web Services of the world?
- Big data analytics software for intelligence community goes commercial
  
  IT shops that need to analyze huge volumes of data can look to a newly available big data analytics tool that was previously reserved for the intelligence community.
Data Management
- Wikibon analyst scopes big data market, predicts explosive growth
  
  Big data technologies challenge the status quo. In this Q&A;, analyst Jeff Kelly sorts through the issues and sees big-time growth in new methods.
- Gartner Magic Quadrant finds rising demand for data warehouse services
  
  A look at the latest Gartner Magic Quadrant for Data Warehouse Database Management Systems and more data management news from around the Web.
- Business capability model helps data pros sell MDM, Gartner says
  
  Data management pros need business buy-in to get funding for MDM initiatives. Modeling business capabilities can help, according to a Gartner analyst.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- Oracle Sun hardware is not for hobbyists, by a long shot
  
  Old Sun enthusiasts lament the way it used to be, and the way it will never be again. Oracle Sun hardware is a whole other animal.
- Why Ray Wang is excited about Collaborate 2013
  
  Find out what analyst R 'Ray' Wang of Constellation Research is most excited about regarding the upcoming 2013 Oracle Collaborate conference.
- What's out there for Oracle third-party tools
  
  Oracle products come with an array of integrated tools, but an ecosystem of third-party tools exists that can make an Oracle developer's life even easier.
Content Management
- Chief content officer can create value from content management noise
  
  The Google Reader RSS controversy could give chief content officers an opportunity to see what matters in content management and what doesn't.
- Rich media flood pushes digital asset management strategy to forefront
  
  Without an effective plan for managing digital assets, the increasing digital content collected by organizations could end up being a real headache.
- Avoid the pitfalls of cloud collaboration management
  
  Analyst Tim Walters explains how to build a strong case for cloud collaboration management and how to avoid problems that pop up along the way.
Windows Server
- Five things you might not know about the Hyper-V virtual switch
  
  One of the most significant improvements in Windows Server 2012 might be the Hyper-V virtual switch. What makes this low-cost option such a big deal?
- A quick look at BitLocker installation requirements
  
  A basic BitLocker installation doesn't require any unusual steps, but deploying it on Windows Server 2012 comes with a few caveats.
- How to use the BitLocker recovery options in Windows Server 2012
  
  BitLocker offers two recovery methods in Windows Server 2012. Our expert defines the options and explains how to use recovery passwords and keys.

All Rights Reserved,Copyright 2005 - 2013, TechTarget