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
Endpoint Protection Manager (SEPM) 14 RTM through 14.3 RU1 using SQL Server
The SEPM server does not have the SQL Native Client installed, or this software is corrupted.
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