SQL Server requirements

SQL Server

Flexxible|SUITE requires a SQL Server installation that hosts the XD and Flexxible|SUITE DBs.

SQL Server could be shared with other apps like Citrix Virtual Apps and desktops or System Center Virtual Machine manager but we don't recommend it. A dedicated SQL Server will have better performance.

The SQL Server instance could be on the Controller VCC Role or in a dedicated VM. Please, refer to the Flexxible|SmartWorkspaces Infrastructure article.


Info

For the proper functioning of Flexxible|SUITE, the specified collation must be 'Latin1_General_100_CI_AI'.

The SQL user must have as default language us_english.


Flexxible|SUITE DB creation user

Integrated authentication

DB without HA

To create a login

  • Create a login for Flexxible|SUITE with the services group specified by the setting "VDIManagerServicesGroup" (e.g. sd\FlexxibleVDIServices):
use master
GO
CREATE LOGIN [SD\FlexxibleVDIServices] FROM WINDOWS WITH DEFAULT_DATABASE=FlexxibleSUITE
GO


DB Always On

The users must be created on all nodes and the users created on all nodes must have the same SID.

Principal node

Execute

CREATE LOGIN [LoginName] WITH PASSWORD= 'pass',
DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english],
CHECK_EXPIRATION=OFF,
CHECK_POLICY=OFF

GO


To recover the sid

select name, [sid] from sys.sql_logins where name = 'LoginName'


On all other SQL nodes

Execute

CREATE LOGIN [LoginName] WITH PASSWORD= 'pass', SID= [sid],
DEFAULT_DATABASE=[master],
DEFAULT_LANGUAGE=[us_english],
CHECK_EXPIRATION=OFF,
CHECK_POLICY=OFF


Permissions

Flexxible|SUITE requires permissions for their proper functioning on their own DB and the Citrix Virtual Apps and desktops DB.

The user must be configured with the following database role for each DB:

  • Flexxible SUITE DB: db_owner

  • XDSite_Logging: public

  • XDSite_Monitor: db_datareader 

  • XDSite_Site: db_datareader, db_datawriter