SQL Error 42000 PeopleSync Admins Not Found

 Problem

During PeopleSync Frontend setup, the following error message is shown:

{SQL_ERROR}: {SQL_STATE: 42000} [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Windows NT user or group '\PeopleSync Admins Typo' not found. Check the name again.

After this, the setup completes normally.

Open

This can happen if during setup, the PeopleSync Admins group you specified cannot be found. Probably, there is a name mismatch between the group you created in AD and the name you entered in the PeopleSync installer.

This group is used to give PeopleSync Console users access to the database. If this group is not properly configured, users wanting to open PeopleSync Console will not be able to do so because of missing database permissions.

 Solution

You can assign permissions for your PeopleSync Admins group manually as follows:

1. Open Microsoft SQL Server Management Studio and connect to the database instance hosting the PeopleSync database, i.e. the one you specified during setup.

2. Go to Security > Logins.
   
   

   Open

   

3. In the contect menu, choose New Login.

4. Make sure Windows Authentication is selected and click on Search.
   
   

   Open

   

5. Click on Object Types and choose Groups. Then search for your admin group and click OK.
   
   

   Open

   

6. Go to User Mapping.

7. At the top, select the PeopleSync database and configure db_datareader, db_datawriter and public permissions.
   
   

   Open

   

8. Click OK to save.

 Related articles