SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Service Accounts
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Peter99
Constraint Violating Yak Guru

471 Posts

Posted - 07/24/2012 :  18:30:04  Show Profile  Reply with Quote
Hi,

I am installing sql server 2008 r2 on stand alone server. We are using service account for database engine and sql agent seperatly. My own account have sqladmin access and added to local administrator on that server. During installation when I tried to use service accounts there is validation errors. Do I need to add these account to local administrator group or what type privileges do these accounts need on that server.

thanks

Peter99
Constraint Violating Yak Guru

471 Posts

Posted - 07/24/2012 :  18:44:32  Show Profile  Reply with Quote
one correction:

These are seperate domain accounts for database engine and sql agent to start these services.
Go to Top of Page

sql-lover
Yak Posting Veteran

54 Posts

Posted - 07/25/2012 :  00:36:46  Show Profile  Reply with Quote
The account that you use for the setup needs elevated privileges on the server or PC in order to run the installation. However, the SQL service and agent account do not need to be part of the local administrator group. In fact, it is not recommended.

It needs certain privileges inside the Windows AD though, but don't remember which one or what. I remember that at my previous work that was a problem when we started moving from SQL 2005 because SQL2008 created some AD objects via SQL service. I honestly don't remember.

The SQL service account needs to be part of "sysadmin" server role though but that's automatically granted during installation. The setup will also ask you if you want to add yourself to that server role.

Also, if you're in a Domain, ensure the PC or server is already attached or part of that Domain; I'm assuming that's true as well.

Maybe if you post the actual error, we can help you more ...

Edited by - sql-lover on 07/25/2012 00:43:18
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000