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.
Related Q&A from Denny Cherry, Contributor
Planning an upgrade to SQL Server 2008? Our expert weighs in on advantages and hardware requirements you should consider before upgrading to SQL ...continue reading
After installing SQL Server 2005, the SQL Server tools may not appear in the start menu. Our expert explains how to troubleshoot this problem.continue reading
Find out where to look for the current amount of SQL Server database disk space being used in your environment.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.