After the successful installation of XenDesktop, when configuring the Desktop Deployment on an external SQL Server 2008, R2 edition, the following error message is displayed:

“The current credentials have insufficient privileges to access the database server and perform the necessary operations. Do you wish to enter alternative credentials?”

Note: This error message is displayed even if trying with different accounts like Domain Admin or Local Admin on the SQL Server.

As a workaround, enable the sysadmin server role for the account that is used on the Delivery Controller (Controller) to create the XenDesktop database:

The account can be the same Active Directory service account used during the installation of SQL Server, but this is not necessary and any other account can be used for this purpose.

After the server role of sysadmin is enabled, the error message on the Controller changes, as displayed in the following screen shot:

“All database connection tests passed.”

Problem Cause

The account used does not have sysadmin enabled as a server role on the SQL Server.

During the installation, SQL Server offers the option of using Local accounts for its services, or an Active Directory account. In this example, the Active Directory service account Admin004 was used for the SQL Service installation; consequently it appears as the logon account for the SQL Server services.

In addition, during the installation, SQL Server automatically creates a login for the service account. The issue occurs in part because in the R2 edition of SQL Server 2008, the account no longer has automatic sysadmin server role.

Citrix SQL Ports 1433/1434 are required - Refer to CTX101810 - Communication Ports Used By Citrix Technologies

CTX127594 - XenDesktop 5.0 Quick Start Guide

CTX128328 - FAQ: XenDesktop 5

CTX127587 - XenDesktop 5 - Reference Architecture