Um - we're talking about the installation here... I would suggest that dbcreator is probably sufficient to create the database, but is the account then dbo for that database? The installation will the need to create tables etc, so dbo is probably the easiest way.
Cheers Ken From: Michael B. Smith [mailto:mich...@theessentialexchange.com] Sent: Thursday, 5 March 2009 1:12 PM To: NT System Admin Issues Subject: RE: SCOM 2007 install issue Yes. You need sa, unfortunately. <shameless plug> You can read my book for some additional details (I've got two chapters on installing OpsMgr and a chapter on SQL Monitoring). </shameless plug> In general, the install and the management pack do so much more than just deal with the OperationsManager database itself, that it requires additional privileges. There are some folks who have tried to cut that back and assign granular permissions, but it tends to reduce the efficacy of the MP. Regards, Michael B. Smith, MCITP:SA,EMA/MCSE/Exchange MVP My blog: http://TheEssentialExchange.com/blogs/michael Monitoring Exchange w/OpsMgr now available http://snurl.com/45ppf From: Christopher Bodnar [mailto:christopher_bod...@glic.com] Sent: Thursday, March 05, 2009 3:28 PM To: NT System Admin Issues Subject: SCOM 2007 install issue Anyone do the single server install of SCOM 2007? Specifically I was wondering what SQL 2005 permissions the account that is installing needs within SQL. Our DBA group did the SQL install and gave my account the dbcreator and public roles within SQL. That does not seem to be enough for the install. Getting the 25154 error with error code -2147217900. I've Googled this and found some hits but none specifically in regards to SQL permissions. I have read through the Deployment guide and the Design guide, and cant' find a specific mention of this. I'm guessing if they give me sysadmin it will work. I'll post this over on MyITforum, but thought I might get a quicker response here. Thanks Chris Bodnar, MCSE Sr. Systems Engineer Distributed Systems Service Delivery - Intel Services Guardian Life Insurance Company of America Email: christopher_bod...@glic.com<mailto:christopher_bod...@glic.com> Phone: 610-807-6459 Fax: 610-807-6003 ________________________________ This message, and any attachments to it, may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are notified that any use, dissemination, distribution, copying, or communication of this message is strictly prohibited. If you have received this message in error, please notify the sender immediately by return e-mail and delete the message and any attachments. Thank you. ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
