Error Message

DLOClient.log file has the following error message:

Connection error: 80004005( 80090322 ) : SQL Server Network Interfaces: The target principal name is incorrect.

The Service Principal Name (SPN) record for SQL has not been registered by the account that is starting the SQL Instance used by DLO.

In the following example on how to resolve this issue, please note:

SQL Server name = SQLDLO
SQL Instance name = DLO
Service account for DLO Admin Service and the SQL (DLO) Service = Lab\Administrator
FQDN of Server = SQLServer.lab.dom

These values will need to be changed in the commands to ones appropriate in the environment which they are being used.

From an Administrator CMD prompt on the Domain Controller or on the SQL Server run the following:

setspn -L Lab\administrator

This command should list the SPN's for the account specified.

   MSSQLSvc/SQLDLO.LAB.DOM:DLO
   MSSQLSvc/SQLDLO.LAB.DOM:1433

If it does not return this information, it means that the SPN has been registered by another account and not the SQL service account.

To find out what account has been registered as the SPN for the service, the following command can be run to attempt to register the SQL service account.

setspn -A MSSQLSvc/SQLDLO.LAB.DOM:DLO Lab\Administrator

If the command cannot register the account for the SPN, it means another account is registered as the SPN and the command output will show you what account that is.

Checking domain DC=Lab,DC=DOM
CN=SQLDLO,CN=Computers,DC=LAB,DC=DOM

Duplicate SPN found, aborting operation!
 

This example means that the Local System Account (LSA) for the SQL server (SQLDLO) is registered as the SPN. This has to be removed so that the Lab\Administrator account can be registered.

The SPN from the Local System Account has to be removed so it can be added to the Lab\Administrator account.

To remove the SPN from the LSA run the following commands.

setspn -D MSSQLSvc/SQLDLO.LAB.DOM:DLO SQLDLO
setspn -D MSSQLSvc/SQLDLO.LAB.DOM:1433 SQLDLO

These commands unregisters the current LSA  from the SPN for the TCP/IP port and the the DLO instance.

Now re-run the command to update the SPN records for the SQL service account Lab\Administrator

setspn -A MSSQLSvc/SQLDLO.LAB.DOM:DLO Lab\Administrator
setspn -A MSSQLSvc/SQLDLO.LAB.DOM:1433 Lab\Administrator

To verify that the SPN is now registered as Lab\Administrator run the following command again:

setspn -L Lab\Administrator

If it returns:
MSSQLSvc/SQLDLO.LAB.DOM:DLO
MSSQLSvc/SQLDLO.LAB.DOM:1433

... the command was successful.

Restart the SQL (DLO) service and the DLO Admin Service and launch the DLO Agent.