How To Change Xenapp 6.5 Sql Account Name?all About Citrix

I'm posting this article because when I was searching for this answer it was hard to find anything that did a good job explaining exactly what needed to be done. This article specifically explains how to tell a XenApp 6 server to point to a different Citrix License Server for its licensing requirements. These instructions may apply to older versions of XenApp also.

All XenApp 7.6 controllers, workers and users accessing the published resources have to be member of a Microsoft Active Directory infrastructure. In XenApp 7.6, Citrix Studio replaces the AppCenter / Delivery Services Console for configuring the environments and provide users with access to applications and desktops. Mar 11, 2017 On the XenApp server hosting the SQL Server Express data store, a new Data Source Name (DSN) must be created for the new SQL database. Go to Start - Administrative Tools - Data Sources (ODBC) and navigate to File DSN tab. Change the Look in to C: Program Files (x86) Citrix Independent Management Architecture as shown below. I am trying to change the STA IDs of an xenapp 6.5 server, since two servers were cloned and they have the same STA IDs in the netscaler. I tried to change the UID in the file C txSta.config under C: ProgramFiles (x86) Citrix System32. Jul 14, 2014 In order to change the Citrix licensing server you need to update the Citrix Computer Policy as well as change two registry entries. Updating the Citrix Policy does not update the registry keys automatically which means if the server is unable to contact the Data Store during a reboot it will revert to these keys, and if they are not correct you will get licensing errors upon logon.

The proper way to do this is to create (or modify) a XenApp computer policy. You will need to add (or modify) the following setting 'License Server Host Name' with the appropriate name of the new license server.
  1. Open the Citrix Delivery Services Console
  2. Drill down into XenApp, then your farm, then click on POLICIES.
  3. Click on the COMPUTER tab within the Policies pain
  4. Depending on your situation you may need/want to create a new policy for this, or you can just edit the 'Unfiltered' policy. I'm assuming if you are reading this you are fairly new to XenApp and are not dealing with a large number of servers, so just using the Unfiltered policy is fine for you.
  5. If you already have the 'License Server Host Name' policy, simply change the server name value to what you want. Otherwise you will need to add the policy with the appropriate server name. Make sure you can ping the name of the license server, exactly how you are entering it, from the XenApp server. Use the fully qualified DNS name for best success. If it is beyond a firewall (or has local firewall settings) that don't allow ping replies then obviously you may not be able to ping it. Just make sure it has the appropriate ports open (typically the range 27000 -27010)
  6. Save the policy and make sure it is enabled.
  7. From my experience you will need to reboot the XenApp servers for it to take affect quickly.


Citrix
HOWEVER - I also figured out that sometimes the servers didn't comply to that policy during a reboot - see my article on that issue here. So to ensure it always points to the correct license server I would suggest also changing the following registry settings with the appropriate server name for the license server. I will assume if you are reading this you know how to do this via REGEDIT. The XenApp policy does NOT updates these settings and they will retain the old license server name unless you change it.
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlCitrixLSName
HKEY_LOCAL_MACHINESOFTWAREWow6432NodeCitrixLicensingMFCM_LSHostName
Change
If XenApp can't find the Citrix license server then your users will not be able to log on!!

Alternate search terms to help people find this article:
  • Change XenApp licensing server
  • Point XenApp to different license server
  • Update Xenapp License server name
  • Control which Citrix License Server is queried by XenApp
  • How to modify XenApp License Server Host Name
  • Citrix XenApp cannot contact the license server

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.


[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

Sql accounting

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 Server

Modify Datastore 1.29 KB

Sql Accounting Software Malaysia

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

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

Tags:

datastoredsmaintdsmaint configdsmaint recreatelhchowto move datastoremf20.dsnmovemove datastoresql serverXenApp

Sql Account Malaysia

Leave a Reply