The target principal name is incorrect. Cannot generate SSPI context. (Microsoft SQL Server)

In order to solve the above error login to your SQL Server

Open A CMD as administrator  and list your current SPNs

setspn -l servername

To change the SQL Server service account from local system to a domain user account remove current SPN from MSSQLSvc/SQLServerName:1433 computer account and add to the domain account.

Remove SPNs

setspn -D MSSQLSvc/SQLServerName:1433 SQLServerName

Add SPNs

setspn -A MSSQLSvc/SQLServerName:1433 Domain\Account

Done!

 MS SQL  
 
Fully optimised SSD hosting

Optimised for WordPress & other applications