Error Message

A Dtrace of Deployment_Scanner will show "The target principal name is incorrect" and Event ID 13360 will be captured in log and the Enterprise Vault Event Viewer log. 

(Deployment_Scanner)    <1234>    EV:H    {CADOContext::CreateConnection:#658} Failed to Open Connection hr: Unspecified error  (0x80004005)
(Deployment_Scanner)    <1234>    EV:H    {DecodeAndLogError:#931} Error Description: [SSL Provider: The target principal name is incorrect.|]
(Deployment_Scanner)    <1234>    EV~E    Event ID: 13360 An error was detected while accessing the Vault Database 'Provider=MSOLEDBSQL19;Data Source=;Integrated Security=SSPI;DataTypeCompatibility=80;Use Encryption for Data=Optional;Trust Server Certificate=False;Host Name In Certificate=;' (Internal reference: CC1): |Description:  |SSL Provider: The target principal name is incorrect.| | |SQL Command: | N/A| | |Additional Microsoft supplied information:| |Source:       Microsoft OLE DB Driver 19 for SQL Server |Number:       0x80004005 |SQL State:    08001 |Native Error: -2146893022 |HRESULT|0xc0043433| |

This error can be caused if the connection is using the short name (NetBIOS) and not the FQDN of the SQL server. 

Update the connections to use the FQDN and not the NetBIOS name for all database connections.  The following EV PowerShell command can be used to update all EV database connections. Update the names for the specific names in the environment. 

Get-EVDatabaseDetail | Where {$_.SQLInstanceName -eq ''} | Set-EVDatabaseDetail -ServerName ''

Use the ,port option if SQL is using a customised (non-standard) port. The following example lists the SQL server NetBIOS name as SQLSERVER using the custom port 7109 in the domain EV.LOCAL:

Get-EVDatabaseDetail | Where {$_.SQLInstanceName -eq 'SQLSERVER,7109'} | Set-EVDatabaseDetail -ServerName 'SQLSERVER.EV.LOCAL,7109'

For more information on the command please refer to the Related Knowledge Base Articles section.