Error: Cannot generate SSPI context - when trying to find a SQL Server in Symantec Installation Manager

Products

• IT Management Suite

Issue/Introduction

In Symantec Installation Manager (SIM) the user is unable to browse for a SQL Server when installing Client Management Suite.  Locate the SIM logs in C:\Users\<username>\AppData\Local\Temp\SIM Logs

From the logs:

The target principal name is incorrect.  Cannot generate SSPI context.

OR

Exception occurred while verifying SQL connection
Failed to open database connection.

The target principal name is incorrect.  Cannot generate SSPI context.

Environment

ITMS 8.6

Resolution

From the logs, all of the errors are this type:

The target principal name is incorrect.  Cannot generate SSPI context.

OR

Exception occurred while verifying SQL connection
Failed to open database connection.

The target principal name is incorrect.  Cannot generate SSPI context.

Researching the SSPI error, it is a Kerberos issue specific to the environment.

Microsoft: https://learn.microsoft.com/en-us/answers/questions/728943/the-target-principal-name-is-incorrect-cannot-gene.html

Stackoverflow: https://stackoverflow.com/questions/32309922/the-target-principal-name-is-incorrect-cannot-generate-sspi-context

Work with the AD / Networking team to add the new SQL Server and SMP server to Kerberos