| With the release of Feature Release 3 for MetaFrame XP Server, Citrix has added the ability to utilize Microsoft SQL Server Desktop (MSDE) for your server farms data store. It is required to install and configure MSDE prior to running the MetaFrame XP Setup program. The following minimum requirements apply to the MetaFrame XP server that hosts the MSDE database. Approximately 50MB of disk space for every 100 servers and 25 applications in the farm 32MB of additional RAM if the MetaFrame XP server will also host connections 70MB of disk space for the MSDE database Note: MetaFrame XP configures MSDE to use Windows NT authentication for the MSDE database. For security reasons, Microsoft SQL Server authentication is not supported. MSDE can be installed with either one of the following methods: SetupMsdeForMetaFrame.cmd - Use this method if you do not have an instance of MSDE already installed on the MetaFrame XP server and you want to use the default MSDE instance name and password values. (Recommended) Run the MSDE Setup program. This method is used if you are not able to use the default instance name and or password. For more information please refer to the Citrix MetaFrame XP Server Administrator Guide. To keep with the scope of this guide I do not recommend steering away from the default settings. For more information on MSDE, please visit: http://www.microsoft.com/sql/techinfo/development/2000/msde2000.asp. The following steps defines how to install MSDE 2000 with Service Pack 3 using the default MetaFrame options. 1. Insert the Citrix MetaFrame XP Server Server CD in the CDROM and browse to \Support\MSDE directory. Double click to execute the SetupMsdeForMetaFrame.cmd, batch file. 
2. The batch file will then install MSDE 2000 with Service Pack 3 and the required default instance of CITRIX_METAFRAME. It sets the MSDE administrator (SA) password to CITRIX. 
3. Reboot the system for MSDE to take affect. Note: The MSDE SA password is required to be set. SQL authentication is not enabled by default when you install MSDE using SetupMsdeForMetaFrame.cmd thus the SA password is not used. Setting the password to CITRIX is not a security risk unless you are using SQL authentication.
If you are upgrading from Feature Release 2 and you use the Microsoft Access data store then I highly recommend you migrate the data store to Microsoft Access to MSDE 200 with Service Pack 3. Citrix has made this very easy with the help of the MigrateToMsde utility. If you experience any issues from the migration you can use the MigrateToMsde utility to automatically roll back any changes that it makes to the system. You can find the MigrateToMsde utility on the MetaFrame XP Server CD in the Support\MSDE folder. The following is the syntax for the MigrateToMsde utility: migratetomsde [/instancename:instancename | /dbname:dbname | /accessuser:user | /accesspwd:pwd | /revert | [/?] The following parameters can be used with migratetomsde.exe at a command line. | Option | Description | | /instancename:instancename | Specify a named instance of MSDE other than the default value of CITRIX_METAFRAME. | | /dbname:dbname | Specify a database other than the default value of MF20. | | /accessuser:user | Specify the username for your Access database if you changed them using the Dsmaint Config utility. | | /accesspwd:pwd | Specify the password for your Access database if you changed them using the Dsmaint Config utility. | | /revert | Reverts to the Access database originally used as the server farms data store. Running this command restores backups that were made when the migration was initially done. Any changes made to the farm since the migration from Access to MSDE are lost. | | /? | Displays the syntax for the utility and information about the utility options. |
The following defines how to use the migratetomsde.exe utility to migrate the Microsoft Access data store to Microsofts SQL Desktop Edition that ships with Feature Release 3. 1. First we need to install and configure MSDE for Citrix MetaFrame Feature Release 3 as described How to Install and Configure Microsoft SQL Desktop Edition (MSDE) section above. 2. Click Start type CMD and click the OK button. Browse to the location of the Citrix MetaFrame XP with Feature Release 3 installation files and type CD \support\MSDE\ folder located on the Citrix MetaFrame XP with Feature Release 3 folder 3. Type migraetomsde and add any of the above options, detailed above, if required. Note: If you have not changed the Access data store settings then you are not required to add any options. 
4. Click OK to proceed with data store migration. 
5. The data store is migrated and you are presented with the overall progress in the Comparison Status window. 
6. Click OK to finish. 
You have now successfully migrated the MetaFrame XP data store to MSDE. |