To Configure the SCOM SharePoint 2010 MP in your case you needed to do the following:
- create domain account on the same domain of the SharePoint 2010.
- Grant this account (local admin + SharePoint farm admin + read on the SharePoint database) on all the SharePoint 2010 Servers.
- Create run as account on your SCOM 2007.
- Add the following lines on the SharePointMP.Config file to configure the SharePoint MP
<Association Account="Run As Account Name" Type="Agent">
<Machine Name="SharePoint Server1 FQDN Name" />
<Machine Name=" SharePoint Server2 FQDN Name" />
</Association>
- Run the “Configure SharePoint Management Pack task.
Please let me know if you need more information.
If the answer help you please mark the answer as proposed.