Solved

service account as admin on server

Posted on 2011-02-15
3
198 Views
Last Modified: 2012-05-11
is the sql service agent being a admin in the box, a good thing, especially if a domain account it is.

any advantage to it?

thanks
0
Comment
Question by:anushahanna
  • 2
3 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 34901373
0
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 500 total points
ID: 34901400
Plus if you have failover cluster configurations, you must use the domain user account.

http://msdn.microsoft.com/en-us/library/ms143504.aspx#Use_startup_accounts

0
 
LVL 6

Author Comment

by:anushahanna
ID: 34908052
thanks.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now