Login failed for user ‘

Solution:

Open the SCOM Console – Administration – Security – Run-As Accounts

image

Data Warehouse SQL Server Authentication Account – Account tab
The Account name: Should be blank – You will see “………………….” in both password fields – this is normal

 

image

Reporting SDK SQL Server Authentication Account – Account tab
The Account name: Should be blank – You will see “………………….” in both password fields – this is normal

image

 

If the account the error is referencing is in either of these Account fields – it will need to be reset

How do I reset the account?

1. Next to Account name – Remove the name – the place the cursor in the first space of the Account Name – hit the space-bar once.

2. Clear the “Password” box – Place the cursor in the first space of the “Password:” field and hit the space-bar once.
3. Clear the “Confirm Password” box – Place the cursor in the first space of the “Confirm Password:” field and hit the space-bar once.
4. The Account name is now blank, and each of the password fields has a single “.”
5. Hit apply – then ok

When you place an account in either the Data Warehouse SQL Server Authentication Account or Reporting SDK SQL Server Authentication Account you are telling SCOM that you have a SQL account already in place that you would like to use to access the database. By leaving these accounts blank SCOM then rolls to accounts listed under “Type: Windows” which is directly below the accounts listed above.

Comments are closed.