SQL Server 2008R2 or SQL R2 installed after the installation of Mirror,xenapp or XenDesktop installation, the database connection tool after installation, the local configuration file will also need to set the failover, details are configured as follows:
Configure the database failover for the Mf20.dsn file for IMA. The configuration is as follows:
[ODBC]
Driver={sql Server Native Client 10.0}
database=xenapp6.5
App=citrix IMA
Uid=ctxadmin
Server=szx01-db
Failover_partner=szx02-db
Trusted_connection=no
Where szx01-db is the database principal and SZX02-DB is the mirror database. SZX03-DB is the witness database server.
This article is from the "Sandshell" blog, make sure to keep this source http://sandshell.blog.51cto.com/9055959/1960943
Xenapp,xendesktop database configuration After installation-details that have been ignored by the vast majority of people