SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using three accounts and 4 different severs for this environment.

Accounts - setup account - farm account - service account

Severs - AppSever - DBSever - etc....

When i try to create a farm in the app sever ( DB is created in the DB sever, logged into app sever with the setup account ) Whats are the permissions i should grant for the setup accout

So far i have given security admin + DB creater + DB owner (for master) but it says the current user does not have permission to connect to the DB

PS : I'm using scripts to create a farm

share|improve this question
I found the solution Have to add DB owner for MODEL DB – DannyRatna Jan 18 '13 at 10:11

Please check the Technet documentaion for this information:

I personaly put the setup account into an ad security group i later reuse as a global farm admins (high previleges for those guys). This group is local admin on all sharepoint related (most times even sql) boxes. On sql I grant the group SYSADMIN rights. That's just my config. Read the technet article to get the information needed for your environment.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.