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

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

| More

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.

| More

  1. Bawang
    April 16th, 2012 at 22:20 | #1

    Thank you!

  2. May 9th, 2012 at 07:15 | #2

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

    Thanks!

  3. July 9th, 2012 at 08:44 | #3

    Thanks for the post, just what I needed.

  4. J├╝rgen
    May 13th, 2013 at 06:35 | #4

    Thanks! You’ve saved my day!

  5. Jeff Hayes
    October 3rd, 2013 at 10:30 | #5

    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.

    Sincerely,

    Jeff

  1. May 15th, 2012 at 04:09 | #1
*


NOTE: Due to increased spam, your comment may not immediately appear on the site until validated.