Delivery controller won't connect to the database after changing the SQL service account to a domain username on SQL Server. When running the SQL.UDL test from the Delivery Controller, we are getting: Microsoft Data Link Error: "Cannot generate SSPI context"

Follow below steps to resolve this issue:

Per https://support.citrix.com/article/CTX209470 the problem could be related to SPNs.(Service Principal name). 

Follow the instructions detailed in the following article to create a new SPN for the SQL database server: https://technet.microsoft.com/en-us/library/bb735885.aspx

• To create an SPN for the NetBIOS name of the SQL Server use the following command: setspn –A MSSQLSvc/<SQL Server computer name>:1433 <Domain\Account>
   
• To create an SPN for the FQDN of the SQL Server use the following command: setspn -A MSSQLSvc/<SQL Server FQDN>:1433 <Domain\Account>

After creating the SPN for the FQDN of the SQL server, DDC should be able to connect to the SQL database with the new credentials and it should restore the studio functionality.


 

---

Problem Cause

Changing the SQL service account from SA to domain user account without changing or creating  SPN  (service Principal name) for the new  SQL Server service account

 

Delivery controller won't connect to the database after changing the SQL service account to a domain username on SQL Server. When running the SQL.UDL test from the Delivery Controller, we are getting: Microsoft Data Link Error: "Cannot generate SSPI context"

Unable to contact Database error "Cannot generate SSPI context" -  https://support.citrix.com/article/CTX209470

How to Configure an SPN for SQL Server Site Database Servers - https://technet.microsoft.com/en-us/library/bb735885.aspx