1 of 1 people found this helpful
how do you have the credentials set on the template? Go to the node and to the application. Click edit and the "chose credential type" what is it set to? Sometime i have to do "auto-detect" and then sometime i have to do "sql server credentials". Usually when it fails for me it's set to "windows credentials".
I tried this and still get the same failure :-(
SO, i did a bit more digging and looked through the SQL Logs.
Even i set the Credential Type to Auto or Windows, i still get the following entry in the SQL error log:
Login failed for user 'XXXXXX\.solarwinds-agent'. Reason: Attempting to use an NT account name with SQL Server Authentication. [CLIENT: <local machine>]
This is working on other servers on other domains fine.
I cant see any differences with the way the accounts are set up.
A SQL credential still works fine.
Found the Issue :-)
The account needs to be granted 'Log on as a Batch Job'
- In the Control Panel, open Administrative Tools, then Local Security Policy.
- Beneath Security Settings, open Local Policies and highlight User Rights Assignment.
- Locate Log on as a batch job. Open the properties and add any users that need this right.
- When finished, save your changes and close the Local Security Settings window.
I'm all working now :-)