Long ago I wrote up this process to facilitate rapid reconfiguration of the SQL datastore on MetaFrame / Presentation Server. A colleague came to me today asking about a way to automate this process on an older Citrix deployment. Ah, sometimes being the old dog comes in handy, happened to know exactly what he needed and BAM! I already had this process written up.
1. Backup of the SQL database
2. Copy the database to the new server
3. Offline or detach the SQL datastore from the existing server
4. Create a SQL account - I usually use ctxuser for the account and ctxpass for the password, but anything you remember works or even SA
5. Attach the SQL datastore on the new server, make sure the SQL account is the db-owner
6. On the Data Collector - Copy the C:\Program Files\Citrix\Independent Management Architecture\mf20.dsn and then edit the original with notepad to change the SQL Server name
7. Stop the IMA service on the Data Collector
8. Run the command dsmaint config /user:ctxuser /pwd:ctxpass /dsn:” C:\Program Files\Citrix\Independent Management Architecture\mf20.dsn” – the quotes are important
9. Restart the IMA service
10. Verify that the server has connected to the new SQL Server
11. Run dsmaint recreatelhc on the server
12. Repeat 6-11 for each server
No comments:
Post a Comment