Change the xenapp database user in a farm

Citrix xenapp

If you have the need to change the user account that your xenapp farm uses to connect to a database you would need to use the dsmaint command.

Firstly however you need to prepare the database for the new user account. Presuming that its a sql database then you would need to use the sql management studio to assign another user the dbo permission to the xenapp database. This should be an active directory account with a long and complicated password that does not expire.
Once you have prepared a new dbo for the database you can then log into the first xenapp server and type in the following:

dsmaint config /user:mydom\newdbo /password:reallylongpa55w0rd /dsn:”c:\locationofdsn”

The dsn object is located on each xenapp server and is called mf20.dsn which is normally located within “c:\progra~2\citrix\independent management architecture\mf20.dsn”.
Once you have typed in the above hit enter and after few seconds you will receive a confirmation that the setting were applied successfully you will need to restart the Citrix ima service within windows.
Hit the start button and type services.msc into the search box the open the services console, scroll down the list until you get to the service entitled “Citrix independent management architecture” and restart it. It will also restart a couple of other services as well, but as long as the ima service starts correctly then you should be good to go.

It is worth testing at this point just to make sure that you can log on to that particular xenapp server by publishing an application only to that server (such as notepad or similar) then test connectivity, this step isn’t really needed but I would do it just to make sure that everything is working correctly.


Author: Dale Scriven

Leave a Reply