Timeout error when trying to populate the group list of the selected domain in the Add a new single sign-on sync group dialog in the Server administrator
Reference Number: AA-00759 Created: 22-05-2015 07:56 Last Updated: 22-05-2015 08:01 0 Rating/ Voters

Title: Timeout error when trying to populate the group list of the selected domain in the Add a new single sign-on sync group dialog in the Server administrator

Symptoms: 

In the Windows single sign-on category of the Server administrator, you can select Active Directory groups to be synchronized in memoQ server. In the Add single sign-on sync group dialog, select a domain. After selecting a domain, the group list is populated. This can  fail with a timeout error or may take a long time for a large Active Directory.


How to:    

Add the single sign-on sync group manually to the database.

Follow the steps below:

  1. Open SQL Server Management Studio and connect to your SQL Server instance.
  2.  List the AccountOrigin table and find your domain. You can find the domain based on the Description field that contains the name of your domain. Remember the AccountOriginID of the record.
  3. Note: The record for your domain gets saved in this table when you enable Single Sign On in using your current Active Directory, e.g. the Enable single sign-on and Use Active Directory through the current domain check boxes are checked, and the settings are saved.
  4.  Insert a new record into the Group table that represents your Active Directory group which you would like to synchronize. The values of the fields in the new record:

SID: generate a new Guid

Name: the name of the AD group

Descripton: NULL

Disabled: False

ServerProjectGuid: NULL

IsBuiltIn: false

WinSID: the objectSid property of the AD group

LanguagePairs: NULL

Deleted: false

AccountOriginId: foreign key for your domain in the AccountOrigin table. Use the AccontOriginID of the previous step.

OriginType: 1

IsSubVendor: false


See also: https://kb.kilgray.com/article/AA-00758/ 



Rss Comments (Please do not post support requests here.)
  • There are no comments for this article.
Info Add Comment
Nickname: Your Email: Subject: Comment:
Enter the code below:
Quick Jump Menu
Info Missing an article? Let us know!