To fix the problem, choose "SQL Server and Windows" as the authentication mode in Microsoft SQL Server.
To choose "SQL Server and Windows" as the authentication mode
On the computer to which you are installing the Symantec ESM Reporting Database Foundation, click Start > Programs > Microsoft SQL Server > Enterprise Manager.
On the SQL Server Enterprise Manager tree, click Microsoft SQL Server > SQL Server Group.
Right-click the database name.
Click Properties.
On the Security tab, click SQL Server and Windows to designate the authentication mode.
Restart the computer.
Install the Symantec ESM Reporting Database Link for MS-SQL. Symantec ESM Reporting Database Foundation creates the ESM and SER databases.