Who Should Own the OnePoint Database?
Goto the MOM Home Page
 
In MOM who should be the rightful owner of the OnePoint Database? Who should be the owner of the Master DB? Is there any specifics you can point me too?

From the microsoft.public.mom.managementpack.sql newsgroup
DBO should be owner for OnePoint database. The person setting up the MOM database should have Admin Rights to create the database (if this person is not an Admin on the box, and just has the correct SQL Permissions, this will typically cause that person to be the database owner on the database).

The Service Account used for the OnePoint Service and OnePointActiveOpsDas COM+ component, need db_datareader and db_datawriter rights on the DB.
 

© FAQShop.com 2003 - 2008

Goto the MOM Home Page

Email the Author