MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Moss Database

  Asked By: Nilay    Date: Apr 24    Category: MOSS    Views: 594

I'm in the process of setting up our MOSS Production server and I'm at
the point in the Config Wizard where I need to "Specify Database
Access Account". I'm not 100% sure which account to use here so I
wanted to bounce this off all of you. I didn't really worry about
this in my test environment so I'm now dealing with it.

Should/can this account be the same domain account we use to run the
SQL Services on our cluster (which is where the MOSS databases will
reside)? Or, should this be a separate account for the purposes of
just accessing the MOSS databases? Can it be one of the service
accounts I use for the other MOSS services?

I currently use 2: moss and mosscontent

Should I have additional ones?

Please, any prompt insight would be greatly appreciated.



5 Answers Found

Answer #1    Answered By: Akshay Gupta     Answered On: Apr 24

I believe it only needs to be an account  that has permissions to the SQL
databases that your MOSS content is in. I can't remember the permissions it
needs off the top of my head.

Answer #2    Answered By: Trinity Scott     Answered On: Apr 24

You can use the existing account. I don't think you need to create new

Answer #3    Answered By: Constance Guerrero     Answered On: Apr 24

ok, I will use the service account  we use to run  all of our SQL Services.

I just wanted to be sure.

Answer #4    Answered By: Chandrabhan Konwar     Answered On: Apr 24

As long as the account  you specify has access DBO access then you
should be fine. Remember that when you get to setting  up shared
services that you should use a separate  account to run  shared

Answer #5    Answered By: Tina Owens     Answered On: Apr 24

That account  should have DB Creator and Security Admin rights in SQL and
be a member of local administrators on all members of the farm.

Didn't find what you were looking for? Find more on Moss Database Or get search suggestion and latest updates.