A Connection Could Not Be Established With The Specified Database when Setting Up Citrix XenApp Configuration Logging

When executing the “Configure Database” wizard for a XenApp farm, the following error is given (Figure 1):

A connection could not be established with the specified database

Unknown error occurred: error code 0x8200003e

Figure 1

This error happens with all current versions of XenApp:

  • XenApp 5 for Windows Server 2003 both 32-bit and 64-bit
  • XenApp 5 for Windows Server 2008 both 32-bit and 64-bit
  • XenApp 6 for Windows Server 2008 R2
  • XenApp 6.5 for Windows Server 2008 R2

This error is easily fixed.   The cause of the error is a mismatch in the default encryption settings between the Configuration Logging database and the Configuration Logging configuration settings.  The default setting for Use encryption in the
Configuration Logging Database configuration wizard is Yes as shown in Figure 2.

Figure 2

The default setting for encryption for the database in SQL Server is False as shown in Figure 3 and Figure 4.

Figure 3

Figure 4

If you want to use Configuration Logging in your XenApp farm, you only have two options.

  1. Change the option in the Configuration Logging Database wizard to No and leave the Encryption Enabled option for the database to False as shown in Figure 5 and Figure 6.
  2. Leave the option in the Configuration Logging Database wizard to Yes and change the Encryption Enabled option for the database to True as shown in Figure 7 and Figure 8.

Figure 5

Figure 6

Figure 7

Figure 8

If you decide to go with using database encryption, you will need to work with your database administrator to set up the proper database encryption key.  Because the data contained in the Configuration Logging database typically does not require high security, in most cases, disabling encryption may be acceptable to your internal Security management; however, your internal security requirements should be verified.  Please see http://tinyurl.com/DBEncryption for more information on encrypting Microsoft SQL Server databases.

Note:  Oracle database support for Configuration Logging is extremely limited.  Please see http://support.citrix.com/article/CTX114501 for a list of supported databases.

Whichever option you decide upon, when you click Test Database Connection (Figure 9)

Figure 9

You will now get a successful connection message (Figure 10).

Figure 10

Your Configuration Logging setup is now complete (Figure 11).

Figure 11

,

About Carl Webster

Webster is a Sr. Solutions Architect for Choice Solutions, LLC and specializes in Citrix, Active Directory and Technical Documentation. Webster has been working with Citrix products for many years starting with Multi-User OS/2 in 1990.

View all posts by Carl Webster

One Response to “A Connection Could Not Be Established With The Specified Database when Setting Up Citrix XenApp Configuration Logging”

  1. Shanetech Says:

    Hi Carl,

    Thanks for putting this together. This is a common issue that is easily overlooked. We recently went over configuration logging in our Xengineer class and I found that this citrix.tv video was very helpful as a training tool. http://www.citrix.com/tv/#videos/2011

    Take care,

    Mark

    Reply

Leave a Reply