"Unexpected server error. ErrorCode: 0x10010000" during login to Endpoint Protection Manager console

Products

• Endpoint Protection

Issue/Introduction

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 the SEPM Home, Monitors, and Reports are blank.

Unexpected server error. ErrorCode: 0x10010000

Environment

• Remote SQL Server
• Windows Authentication

Cause

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

Resolution

This issue can be caused by multiple items. Please review and verify all of the listed resolution steps.

1. Quick check:

Restart the database server

2. User Account permissions

• Add the database user account to the Local Administrators group on the SEPM server.
• Refer to Microsoft documentation for steps on adding members to a local group.
  • Article: http://technet.microsoft.com/en-us/library/cc772524.aspx

3. SQL database Windows user password reconfiguration

• Navigate to Start > Symantec Endpoint Protection Manager > Management Server Configuration Wizard (MSCW)
• Select Reconfigure the management server.
• Select the Microsoft SQL Server database option.
• Enter the new password and complete the wizard

If you have done these steps and the issue is still present, please open a support case for further investigation.

Additional Information

Error: "Unexpected server error" when logging in to Endpoint Protection Manager
Changing the password for an administrator account or the default database
Reinstalling or reconfiguring Symantec Endpoint Protection Manager