topic Re: SCOM HPE OneView DB Login failed ... in HPE OneView

SCOM HPE OneView DB Login failed ...

WOPS — Wed, 08 Apr 2020 09:37:19 GMT

Hi all

On the sql server for SCOM DB, I have multiple following errors every minute from HPE SCOM "run as profile account":

04/08/2020 10:50:15,Logon,Unknown,Login failed for user 'Domain\UserHPOneView'. Reason: Could not find a login matching the name provided. [CLIENT: XXX.XXX.]
04/08/2020 10:50:15,Logon,Unknown,Error: 18456

Environment:

SCOM 2019 UR1
SQL Server 13.0.5492
OneView appliance 5.00.01-0410269

What permission on the DB is needed, I don't see any information on the HPE OneView Virtual Connecto for System Center.

Best regards,

Francesco

Re: SCOM HPE OneView DB Login failed ...

Anurag_Soni — Wed, 08 Apr 2020 15:16:51 GMT

From your question, it seems that "RunAs Profile" configured for HPE OneView discovery and monitoring do not have sufficient privilage to run the workflows. Please either use appropriate user or the default SCOM service account to run the workflows. You can try to delete the user from "RunAs Profile" configured for HPE OneView discovery/monitoring. It will then use the default service account.

Please confirm if the issue is resolved, Else raise a support case with HPE.

Re: SCOM HPE OneView DB Login failed ...

AmRa — Thu, 09 Apr 2020 07:41:49 GMT

Please check the security settings to confirm whether SQL server is set up to allow both Windows and SQL Authentication.

Also please check User Permissions.

Re: SCOM HPE OneView DB Login failed ...

erki72 — Tue, 05 Jul 2022 06:48:45 GMT

Hi @Anurag_Soni @WOPS @AmRa

It's been a while and I'm still wondering if you've made any progress on this topic.

Unfortunately I have exactly the same problem.
What I'm still interested in, why does the Run AS account have to have permissions to the DB on the SQL server?

Is there any technical documentation on which SCOM DB the user must have exactly which authorizations?

Re: SCOM HPE OneView DB Login failed ...

Sunitha_Mod — Thu, 07 Jul 2022 07:01:02 GMT

Hello @erki72,

Thank you for reaching out to us! Since you have posted in an old topic and there is no response yet, I would recommend you to create a new topic using the create "New Discussion" button, so the experts can check and help you further.

Re: SCOM HPE OneView DB Login failed ...

erki72 — Thu, 07 Jul 2022 12:52:14 GMT

Hi @Sunitha_Mod

Thank you for your message.
Then I will create a new post. Didn't want to open a new topic for the exact same problem...

That's why I tried it here