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

Ask the Expert

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

There are Comments. Add yours.

Sort by: Oldest Newest

Next

View All Comments

Back to top

More from Related TechTarget Sites

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

Business Analytics
- R programming language demands the right use case
  
  The R programming language is becoming more popular in commercial settings, but users have to make sure it fits their needs.
- Close the deal on using CRM analysis to boost customer knowledge
  
  Customer relationship analysis holds the key to improved marketing and customer engagement. But it starts with having the right tools and skills.
- Talking Data podcast: Professional athletics adopts sports analytics
  
  Professional teams are moving quickly to adopt sports analytics. But not everyone is sold on the benefits of data analysis.
Data Center
- IBM Watson to aid in brain cancer cures through big data analytics
  
  IBM's collaboration with The New York Genome Center is built around Watson, which could hasten brain cancer cures and solve big data problems to boot.
- BlackBerry, Dell execs answer mobile, cloud questions in #TechCIT chat
  
  Miss our #TechCIT Tweet Chat? Here's a recap of what execs from BlackBerry, Dell, IBM and Microsoft said about their mobile and cloud strategies.
- IT analytics tools bring big data to work in the data center
  
  IT analytics tools are bringing big data processing techniques into the data center, for faster, more informed infrastructure management decisions.
Data Management
- McKnight: In-memory technology finds lane in database mainstream
  
  In a Q&A;, consultant William McKnight discusses the potential benefits of in-memory processing and its recent inroads with top relational databases.
- Strata big data conference sees tools edging toward chasm
  
  At the Strata big data conference, Geoffrey Moore looked to apply Chasm Theory to Hadoop and the like, as described in our podcast.
- Hadoop 2 query: Less talk, more action with new Hadoop version?
  
  For all the hype about Hadoop, adoption remains relatively low. But the Hadoop 2 release could give prospective users more reasons to move forward.
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
- Handling database migrations, such as upgrading to Oracle 12c
  
  IOUG President Michelle Malcher talks about database migrations, from finding downtime to test and upgrade, to maintaining patch sets after go-live.
- Memphis to make assets out of infrastructure with EAM implementation
  
  Memphis CIO Ben Nair explains how his city's plans to implement Oracle EAM will create a more efficient government and make the trucks run on time.
- Oracle hardware hit the valley, but can it climb the hill?
  
  Some news on Oracle's most recent quarterly earnings, including an Oracle hardware turnaround, Database 12c and cloud.
Content Management
- Why information management strategy is the new agenda
  
  Records managers have exploding volumes and types of content to manage. This proliferation is part of the new information management strategy agenda.
- Is social media records management still too vague?
  
  NARA has developed guidance for governmental agencies on social media-based records management. But are the recommendations too vague to be useful?
- Social media publishing for viral promotion of company content
  
  Regular people like self-published author John Locke have used social media publishing to promote their content virally. Enterprises can do the same.
Windows Server
- Five reasons to run Hyper-V in Windows Server 2012 R2
  
  There's plenty to like about Hyper-V in Microsoft's latest OS. Here are the five top features.
- Microsoft delivers critical IE, DirectShow fixes on Patch Tuesday
  
  Microsoft's Patch Tuesday updates include fixes for Internet Explorer and DirectShow. Plus, Windows XP support nears its end.
- Taking a closer look at ODX file transfer requirements
  
  Offloaded data transfers include a number of hardware and software requirements, but they can support virtualization.

All Rights Reserved,Copyright 2005 - 2014, TechTarget