KB45661: "The security database on the server does not have a computer account for this workstation trust relationship" error message is seen when running a report after configuring Microsoft SQL Server with Integrated Authentication in MicroStrategy 9.x

Sample Code/Error

(QueryEngine encountered error: The target was not recognized. System Error 0x000006FB (1787): --- The security database on the server does not have a computer account for this workstation trust relationship.. Error in process method of Component: QueryEngineServer, Project <PROJECT NAME>, Job <Job ID>, Error Code= -214721544.)

 
If WireShark is used to get a network trace for troubleshooting Kerberos, it is seen that the SPN (Service Principal Name) of the Intelligence Server was not found.
 
Sample Code/Error

KDC_ERR_S_PRINCIPAL_UNKNOWN

 
CAUSE:
 
One possible cause is that the user running the report is linked to a user that belongs to a different domain than in which the Intelligence Server is located.
 
ACTION:
Strategy currently supports only one domain when using Integrated Authentication with the warehouse. To resolve the issue, ensure that the user running the report belongs to the same domain in which the Intelligence Server is located.