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
Data Warehouse SQL Server Authentication Account - Account tab
The Account name: Should be blank - You will see "......................" in both password fields - this is normal
Reporting SDK SQL Server Authentication Account - Account tab
The Account name: Should be blank - You will see "......................" in both password fields - this is normal
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