Hi Stew,
When troubleshooting any error first attained the nature of the error, then look at it in it’s most basic form. So you have an error in SCOM that the password is incorrect for a SQL Server, so here are the steps I would take to troubleshoot. The Master DB holds the Config info for the SQL hence the errors.
o What is the authentication model for the SQL Server; SQL/Windows.
o Is the account used anywhere else
o With this information see if the account has expired
o Check in the SQL Logs for error messages
o If there is logon errors on the SQL we still cannot rule out that Ops Mgr is creating the problem, as if a “RunAs” account is incorrect this would have the effect
o When you have the account then try using that account to log on to the SQL Management console
o If that has not worked address that account;
o If it did work then we need to start to look at the rights of the account you are using in the Security section of the Sql Management console.
o Also you can have a look at the Agent’s logon rights
o If all is good then go back to the Ops Mgr console check out the “RunAs” account
When and if you change anything then change once wait refer to the logs to see it it has sovled the issue, change two or more things at the same time which one solved the problem?