Error " Login Failed for user '<Domain name\computer name>' when trying to run a report using Control Compliance Suite (CCS) 9.0 Reporting and Analytics.
Last Updated September 03, 2010
Error " Login Failed for user '
' is reported in the failure tab for the job run.
Symptoms Report generation is failing with error "Login failed for user <Domain name\DPS machine>
" despite configuring SQL database to use windows Authentication and same error is logged in Microsoft SQL logs
Data Processing service is running under the context of a Local System Account which does not have permission to logon to SQL server.
Change Symantec Data Processing Service to run using the Domain User account with permissions to logon to SQL database.
Setup the Symantec Data Processing Service with a Domain User Account
On the computer with the collector installed, right click My Computer, and click Manage.
In Computer Management console, under Services and Applications, click Services.
Right-click on the Symantec Data Processing Service and click Properties.
Click the Log On tab.
Then click the This account radial button and enter the username and password for the account you wish to use, then confirm the password.
Click on OK
Imported Document ID: TECH115597
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe