[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Xenapp 6.5 - Lost connection to SQL datastore - Users no longer able to logon

Posted on 2014-03-12
Medium Priority
Last Modified: 2014-04-11
Hi all,
We recently had an issue whereby our SQL server which holds the Xenapp 6.5 datastore crashed. My understanding was that the Citrix farm should still allow users to logon by using the LHC on the server. However, no one could log on. What is the default behavior when the elected host loses the connection to the SQL server? and is this something I can change?
Question by:Matt
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 25

Expert Comment

by:Sekar Chinnakannu
ID: 39923310
LHC had a grace period of only 96 hours it means licensing information stored on the data store. Once the 96 hour grace period ended then the licensing will fail and the server will stop accepting incoming connections.

Author Comment

ID: 39923317
this was within 6 hours

Expert Comment

by:Vijaya Reddy Pinnapa Reddy
ID: 39924135
Have you rebooted the server or restarted Citrix IMA service?. If Yes, then citrix farm don't allow users to logon.
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

LVL 37

Expert Comment

by:Carl Webster
ID: 39924507
Man the 96 hour thing hasn't applied since like 2005 or maybe earlier.  If the SQL Server goes down, a XenApp server (if it has made at least one connection to the license server) will serve users for a very long time.  There is no 96 hour or 30 day time limit - there is NO time limit.

If you have lost connection to the license server then the 30 day (768 hour) license grace period comes in.

I have seen instances when then SQL server goes down or the connection to the database goes down then the XenApp server(s) refuse to allow connections.  It is NOT supposed to happen but it does.  In these instances, we implemented SQL mirroring where each SQL server was on a different virtual host and the databases were on different storage systems.

Author Comment

ID: 39925090
Thanks Carl but that's pretty poor. Its not meant to happen but does. I thought the whole point of the architecture was to allow things to keep working if the database connections goes down. Perhaps I should just revert back to my presentation 4.5 farm as it seems far more resilient. SQL mirroring. cluster, or whatever layer of resilience you want to add. You will still at some point run into a database connection problems. The problem is with XENAPP
LVL 37

Expert Comment

by:Carl Webster
ID: 39925096
I agree but I have seen this happen with PS4.5, XA5, XA6 and XA6.5.
LVL 19

Assisted Solution

basraj earned 750 total points
ID: 39925433
Ideally it should work even when the datastore goes down and it happened in my environment too but it never stopped working. When it went down it affected all the servers or only the specific server? If specific server, did you disturb them after DS went down? Like rebooting, restarting IMA and so on? Also is your farm configured with configuration logging?

Author Comment

ID: 39944890
Where can i check if configuration logging is enabled? basically my farm lost the SQL server and 1 of the data collectors. Web interface server was still available. Yet no connections aloud.
LVL 37

Accepted Solution

Carl Webster earned 750 total points
ID: 39944892
right click the farm name

Featured Post

What’s Wrong with Your Cloud Strategy ?

Even as many CIOs are embracing a cloud-first strategy, the reality is that moving to the cloud is a lengthy process and the end-state is likely to be a blend of multiple clouds—public and private. Learn why multicloud solutions matter in this webinar by Nimble Storage.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

After several days of searching and hunting for limited documentation, I wanted to share this guide to hopefully save someone the hassle of trying to figure this out on their own. I have tested this on Xendesktop 7.1 and PS 4.5 running simultaneous…
Citrix policies are the most efficient method to configure and tune XenDesktop environments, allowing organizations to control connection, security and bandwidth settings based on various combinations of users, devices or connection types.  Citrix …
How to install and configure Citrix XenApp 6.5 - Part 1. In this video tutorial we have explained step by step installation of Citrix XenApp 6.5 Server on Windows Server 2008 R2 is explained in this video. We have explained the difference between…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question