Citrix XenApp 6.5 Lesson 2 Installing the first XenApp server into the farm. How to Install SQL Server 2012 Express and SQL Server Management Studio 2012 Express - Duration: 17:27. This does not work for me (XenApp 6.5). When I run this it will log off ALL of the users sessions/applications not just the one I want. For example: user AD John.Doe has Word, Notpad and 3rdPty app open. I run this command to close Word. It will close ALL apps. Is there an update or something I am missing to running this? Jul 10, 2015 How to Configure Citrix XenApp Server 6.5- Step by Step guide. We have already learned the steps to install Citrix XenApp 6.5 on Windows Server 2008 R2.After you are done with the installation steps, next step is to configure individual roles.

1. How To Change Xenapp 6.5 Sql Account Name All About Citrix Login
2. How To Change Xenapp 6.5 Sql Account Name All About Citrix Workspace
3. Sql Accounting
4. How To Change Xenapp 6.5 Sql Account Name All About Citrix Password

Howto move your XenApp Datastore (SQL)

We’re currently decommissioning our W2K3 servers. Part of the process is to move the datastore to a W2K8R2/SQL2008R2 server. Easy job, documented well. Here’s to another document about it 😎

First run a full backup of your database on the source SQL server. Copy the .bak file to your target SQL server. On the target SQL server create a new database (remember the name). Restore the backup to the newly created database. Select ‘Overwrite the database’ in your restore options, else you’ll get an error.

After your restore is completed create a sql login that is db_owner to your datastore. You can limit these permissions to db_reader and db_writer, however every time you update your farm you will need to change these permissions back to db_owner. So I guess it’s not recommended.

Now that your SQL work is done you can start migrating your servers. It’s not a tough job. Just get a MF20.dsn file (%programfiles(x86)%CitrixIndependent Management Architecture folder) of a random XenApp server and edit it with notepad to insert the new connection data. Below the contents of my MF20.dsn file.

How To Change Xenapp 6.5 Sql Account Name All About Citrix Login


[ODBC]
DRIVER=SQL Server
UID=
DATABASE=[sql_db_name]
APP=Citrix IMA
SERVER=[sql_server_fqdn]
Description=[description]


Now one-by-one logon to your servers. Perform the following sequence:

net stop imaservice /y
Stop IMA and it’s dependencies

copy [path_to_new]mf20.dsn %programfiles(x86)%citrixindependent management architecture /y
Copy the new mf20.dsn and overwrite the old one

dsmaint config /user:[sql_login] /pwd:[sql_password] /dsn:'C:Program Files (x86)CITRIXIndependent Management Architecturemf20.dsn'
Connects IMA to the datastore. Gives a succes or failed message

dsmaint recreatelhc
Recreates the Local Host Cache

net start imaservice
Starts IMA

That’s all there is to it.

Update: I wrote a powershell script to automate this process. You can download it if you are logged in.

How To Change Xenapp 6.5 Sql Account Name All About Citrix Workspace

Feel free to download and use this file, but at your own risk.

Sql Accounting

How To Change Xenapp 6.5 Sql Account Name All About Citrix Password