We’re using Universal Type Server (UTS) for our Font Management, UTS is set to authenticate against our AD with security groups giving access to various Font Workgroups.

As we’ve such a large AD, we’re using an MS SQL Database to host all of our user records.

This is all working well, except the default user settings are as per the above, the below advises what we wished to change the default setting to and how this was accomplished.

Wanted settings

We wished to change this to the below for all users.

The solution

Turns out this can be achieved by running the following commands on our MS SQL Server, to do so you’ll need to open a DOS prompt.

SQLCMD
use UTS
GO
UPDATE font__font_clientSettings SET font_clientsettings_replication_policy = 'all' WHERE font_clientsettings_replication_policy = 'on-demand-local-cache';
UPDATE font__font_clientSettings SET font_clientsettings_has_personal_workgroup = 'T';
UPDATE font__font_clientSettings SET font_clientsettings_personal_workgroup_is_local = 'T';
UPDATE font__font_permissions SET font_permissions_canactivateacrossworkgroups = 'T';
GO

Now all users have their settings set as above & the additional admin time for creating Font users is virtually zero.