For information regarding current database support, refer to CTX114501 – Supported Databases for Citrix Products. This article will remain available for informational purposes only.
Summary
This document provides information to customers who may wish to use the latest SQL Server 2005 database for the following:
• Citrix Presentation Server 4.5
• Presentation Server 4.0
• The Resource Manager Summary Database for Presentation Server 4.5
• The Resource Manager Summary Database for Presentation Server 4.0
SQL Server 2005 support
The SQL Server 2005 Service Pack 2 database is supported as a valid database platform for the Resource Manager Summary Database and the IMA data store on Presentation Server 4.5.
The SQL Server 2005 Service Pack 1 and earlier database is supported as a valid database platform for the Resource Manager Summary Database and the IMA data store.
Administrators that want to use this database platform should follow all guidelines in the Citrix Presentation Server Administrator’s Guide and the Advanced Concepts Guide that reference SQL installations.
Citrix has verified the usage of the SQL Server 2005 Service Pack 2 database with the IMA data store (including migrations from one database to another) and Resource Manager Summary Database for Presentation Server 4.5.
The IMA data store has been verified on SQL Server 2005 Service Pack 1 and earlier.
Note: For SQL Server 2005 compatibility with Resource Manager, install CTX111419 – Hotfix Rollup Pack PSE400W2K3R03 - For Citrix Presentation Server 4.0, Citrix Access Essentials 1.0 and 1.5 for Windows Server 2003 . This fix was introduced in CTX109307 – Hotfix Rollup Pack PSE400W2K3R02 - For Citrix Presentation Server 4.0, Citrix Access Essentials 1.0 and 1.5 for Windows Server 2003 (CPR 129864).
More Information
CTX110534 – SQL Server 2005 Configuration for Resource Manager Summary Database
CTX111345 – A Presentation Server Fails to Join the Server Farm in a SQL Server 2005 Replicated Environment
CTX114213 – Supported ODBC Database Versions for the Data Store
