Failed to create the ODBC data source when running the Configuration Wizard, followed by error: "Unexpected server error 0x10010000" upon login

Products

• Endpoint Protection

Issue/Introduction

Symptoms: 

When completing the Management Server Configuration Wizard you see the follow error:
"Failed to create the Open Database Connectivity (ODBC) data source
Check the details in the install log file, correct the issue and try again"

Note: You can hit OK, and ignore the error to complete the wizard, but when logging into the Symantec Endpoint Manager (SEPM) you see further errors such as: "Unexpected server error 0x10010000"

"Failed to create the ODBC data source
Check the details in the install log file, correct the issue and try again." 

 "Unexpected server error 0x10010000"

SCM-Server-0.log will show the following error:  

2018-10-01 19:37:36.722 THREAD 210 SEVERE: com.sygate.scm.common.communicate.CommunicationException: Failed to connect to the server.
Make sure that the server is running and your session has not timed out.
If you can reach the server but cannot log on, make sure that you provided the correct parameters.
If you are experiencing network issues, contact your system administrator. ErrorCode: 0x80020000 

DB_Connection-0.log may show: 

2018-10-02 00:00:34.719 THREAD 223 WARNING: AgentSweepingTask: (db conn) Return Connection Error-> can't find connection (hashcode=0) in the map, total count=1

DBConnectionProxy-0.log may show: 

2018-10-01 16:04:23.892 THREAD 25 WARNING: NT impersonation expired or not done

Configuration wizard log showing:  

2018-09-28 16:22:33.110 THREAD 46 WARNING: DatabaseUtilities> hasUserAlterAnyLoginPermission>> Account permission verification started... dbAccountName: <domain\user>
2018-09-28 16:22:33.157 THREAD 46 WARNING:  MS SQL Win login - impersonate required with custom user id, password.
2018-09-28 16:22:33.157 THREAD 46 INFO: Begin NT impersonation for user: <domain/user>
2018-09-28 16:22:33.298 THREAD 46 INFO: End NT impersonation 
2018-09-28 16:22:33.298 THREAD 46 INFO: DatabaseUtilities> hasUserAlterAnyLoginPermission>> Getting the permission
2018-09-28 16:22:33.360 THREAD 46 INFO: DatabaseUtilities> hasUserAlterAnyLoginPermission>> Account: <domain\user> has the permission: CONNECT SQL
2018-09-28 16:22:33.360 THREAD 46 INFO: DatabaseUtilities> hasUserAlterAnyLoginPermission>> Account: <domain\user> has the permission: SHUTDOWN
2018-09-28 16:22:33.360 THREAD 46 INFO: DatabaseUtilities> hasUserAlterAnyLoginPermission>> Account: <domain\user> has the permission: CREATE ENDPOINT
2018-09-28 16:22:33.360 THREAD 46 INFO: DatabaseUtilities> hasUserAlterAnyLoginPermission>> Account: <domain\user> has the permission: CREATE ANY DATABASE
2018-09-28 16:22:33.360 THREAD 46 INFO: DatabaseUtilities> hasUserAlterAnyLoginPermission>> Account: <domain\user> has the permission: CREATE AVAILABILITY GROUP
2018-09-28 16:22:33.360 THREAD 46 INFO: DatabaseUtilities> hasUserAlterAnyLoginPermission>> Account: <domain\user> has the permission: ALTER ANY LOGIN
2018-09-28 16:22:33.360 THREAD 46 WARNING: DatabaseUtilities> hasUserAlterAnyLoginPermission>> Found the required permission.
2018-09-28 16:22:33.360 THREAD 46 WARNING: DatabaseUtilities> hasUserAlterAnyLoginPermission>> Account permission verification done! hasRequiredPermission: true
2018-09-28 16:22:33.392 THREAD 46 SEVERE: DBConfigHelper> createODBC>> ODBC creation failed. Error message: 
Failed to create the ODBC data source. 
Check the details in the install log file, correct the issue and try again.
2018-09-28 16:22:43.173 THREAD 46 INFO: OdbcUtil> setRequiredACLsForWindAuthODBCTesting>> Setting ACLs for bin, SysUtil.exe, ODBCUtil.exe, DBCUtil.properties..
2018-09-28 16:22:43.189 THREAD 46 INFO: ServiceUtil> execCmd >> Started. Command = [C:\Program Files (x86)\Symantec\Symantec Endpoint Protection Manager\tomcat\..\bin\ServiceUtil.exe, -queryIISAnonymousUserName],Start time: Fri Sep 28 16:22:43 BST 2018
2018-09-28 16:22:43.298 THREAD 46 INFO: ServiceUtil> execCmd>> Finished. Return code = 12,Finish time: Fri Sep 28 16:22:43 BST 2018
2018-09-28 16:22:43.298 THREAD 46 WARNING: ServiceUtil> execCmd>> Process output:
-1    Unable to obtain pointer to IUnknown interface. Error Code = 0x800401e4

 

Cause

The SEPM server does not have the SQL Native Client installed, or this software is corrupted. 

Environment

Endpoint Protection Manager (SEPM) 14 RTM through 14.3 RU1 using SQL Server

Resolution

Install or repair SQL Native Client, which is required for a functional SEPM. And/or un- and re-install the SEPM.

For more instructions see Install SQL client components for Endpoint Protection Manager