Citrix Server needs SQL server?

Question

Citrix Server needs SQL server?

Engo Po

Grasshopper

Points: 13
More actions
May 14, 2007 at 9:20 pm

#153587

Hi there, I am not a technical person. I wish someone could tell me if a SQL server is needed for Citrix Server? If yes, what for? Thanks for help in advance.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Anders Pedersen SSChampion Points: 11410 More actions · Answer 1

I do believe Citrix can use SQL to store information about users. Mostly an issue where you have a Citrix farm I imagine.

Engo Po Grasshopper Points: 13 More actions · Answer 2

Thanks for the info. So it is not a mandatory requirement for Citrix to pair with SQL. This certainly helps.

EdVassie SSC Guru Points: 60472 More actions · Answer 3

My understanding is that by default Citrix will use a MS-Access database to hold its critical information. You have an option to use SQL Server in place of Access.

You need to take a view about how safe it is to hold any data you may wish to access in the future in Access, or if you prefer to hold it in a safe place such as SQL Server.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Paul Yearron SSC Veteran Points: 294 More actions · Answer 4

Hi, Citrix needs to create a datastore in either access or SQL or Oracle. The datastore is very important as it holds all of the user information, the applications available and every other part of the static Citrix farm info.

A word of warning don't be tempted to use access as the Datastore even for very small farms.

We configured a Citrix server 5 years ago as we only needed one, but then added a second about 2 years later. We now want to commission 2 new servers in replace of the old ones. The problem is that you can never remove the original server from the farm as it contains the data store. Also if it fails then you cannot add applications to the farm until you re-instigate that server. It is possible to migrate the datastore from Access to SQL but this can be a tricky process.

However if you use SQL you can easily backup and restore this database if you need to. Even if you don’t have a full blown SQL server you can use the smaller and free SQL express or msde version.

Hope this helps.

Engo Po Grasshopper Points: 13 More actions · Answer 5

Hi, your insight is certainly very helpful. Thanks very much for your response.