SCOM2007 - Login failed for user ''.

When selecting option for Reports within the SCOM Reporting Console - it returns the error: Login failed for user ' <Account name>'.

 

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.

 

>edwalt