You installed Symantec Endpoint Protection Manager (SEPM) with a remote SQL server and configured the database user account (default username sem5) to authenticate with Windows Authentication as a domain user account.
When you log on to the SEPM, the reporting component fails with an unexpected server error, and Home, Monitors, and Reports are blank.
Unexpected server error. ErrorCode: 0x10010000
Possible scenarios:
1. The PHP component, php-cgi.exe, cannot access the necessary files in SEPM because the database user account is not permitted to do so.
2. The password of the Windows user for SQL database authentication was changed.
The below error is found in reporting.log: ERROR:fatal error at login: \r\nEXCEPTION block1: Error message: <b>Source:</b> Microsoft OLE DB Provider for ODBC Drivers<br/><b>Description:</b> [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user ''.\r\nError code: -2147352567\r\nFile and line: C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\Php\Include\Common\ado.php(99)\r\n
1. User Account permission:
To resolve this issue, add the database user account to the Local Administrators group on the computer on which you have installed SEPM. For more information, see the following Microsoft web page:
Add a member to a local group
http://technet.microsoft.com/en-us/library/cc772524.aspx
2. Password of the Windows user for SQL database