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

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

book

Article ID: 158031

calendar_today

Updated On:

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 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

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

  • On the Windows Start menu, navigate to Symantec Endpoint Protection Manager > Management Server Configuration Wizard (MSCW)
  • Click Reconfigure the management server, and then click Next > Next
  • Proceed with the "Microsoft SQL Server database" option, click Next then type the new password on the next page to Finish the MSCW

Additional Information