Connect with us

Hi, what are you looking for?

Citrix XenApp

Changing SQL account name, password, or database server name in XenApp 6.5

If you have a Citrix XenApp environment and change your SQL server, you will need to edit your mf20.dsn with the new server name. Located at:

C:\Program Files (x86)\Citrix\Independent Management Architecture\mf20.dsn

If you changed your SQL credentials, you will need to specify the new user name as well here. If you just change the password only and nothing else, you don’t need to edit your mf20.dsn file. But you will still need to set the new password or the IMA Service won’t start.

Once you make whatever changes you need to the mf20.dsn or not if it’s just a password change, do the following:

1. Go to Services and stop the IMA service (Citrix Independent Management Architecture) if it is still running.

2. Open command line and Navigate to:

C:\Program Files (x86)\Citrix\Independent Management Architecture

3. Type:

dsmaint config /user:yourdomain\youraccount /pwd:yourpassword /dsn:"C:\Program Files (x86)\Citrix\Independent Management Architecture\mf20.dsn"

4. Restart the IMA Service

5. You can also recreate the local host cache database (LHC database) if you have issues starting the IMA service after this. Type:

dsmaint recreatelhc

then restart the IMA Service. It will populate the cache immediately with info from the datastore.



  1. Bawang

    April 16, 2012 at 10:20 PM

    Thank you!

  2. Matt

    May 9, 2012 at 7:15 AM

    Thanks for this information. We recently had to go through this ourselves and your post made it much easier to get teh job done.


  3. Pingback: Backflip Phone

  4. David Gardner

    July 9, 2012 at 8:44 AM

    Thanks for the post, just what I needed.

  5. Jürgen

    May 13, 2013 at 6:35 AM

    Thanks! You’ve saved my day!

  6. Jeff Hayes

    October 3, 2013 at 10:30 AM

    Hello Jason,

    I assume works exactly the same way for Provisioned XenApp targets? Do this in the maintenance version..promote…and then it updates for all streams targets?

    Please advise at your leisure.



  7. svetlana

    June 2, 2014 at 8:03 AM

    Hello, Jason. Your site is cool! Thank you very much.
    I have XenApp65 farm and domain account as system administrator for my farm, this domain account is used in MS SQL farm-database as a dbo.
    I want to change password for sysadmin. How to do this on? Can you give me advice or any link to read?

    Best regards
    Svetlana Astahova

  8. john

    May 25, 2016 at 5:18 AM

    Thanks, good clear info

  9. joel

    October 20, 2016 at 7:39 PM

    Do I need to do this in all xen App servers?

Leave a Reply

Your email address will not be published. Required fields are marked *

You May Also Like


Today I would like to go over proper URL redirection when using SSL but first I would like to preface this by describing what...

Citrix Workspace

You can use FIDO2 hardware security keys plugged into your physical desktop over the Citrix HDX remoting protocol for use with virtualized Windows Desktop...

Exchange 2003

A useful Exchange 2003 guide I wrote for a friend’s blog originally but I am posting it here on mine now for your viewing...


In a worst case scenario and all your web servers have failed, what do you do? You could have a standby group of servers... began in 2008 as a way for me to give back to the IT community. This website features the latest news and how-to's on enterprise mobility, security, virtualization, cloud architecture, and other technologies I work with. This website has evolved over time to become a go-to reference hub for these technologies. It receives hundreds of thousands of unique visitors from all over the world each month. More details on the About Me page.
Copyright © 2008-2023