Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-07-24 : 18:30:04
|
| 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
498 Posts |
Posted - 2012-07-24 : 18:44:32
|
| one correction:These are seperate domain accounts for database engine and sql agent to start these services. |
 |
|
|
sql-lover
Yak Posting Veteran
99 Posts |
Posted - 2012-07-25 : 00:36:46
|
| 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 ... |
|
|
|
|
|
|
Service Accounts