Problem
When opening PeopleSync Console, the following error message is shown:
Solution
This error may be shown when the user running the console doesn't have permission to access the PeopleSync database.
In some cases, it helps to start the console with elevated permissions, i.e. “run as administrator”.
Other causes are as follows:
the database has been moved or renamed
no connection to the database
an upgrade was performed without updating the database.
The most common cause though is a lack of permissions.
To use the console, you must have at least db_datareader and db_datawriter permissions in the PeopleSync database. During PeopleSync backend setup, an administrators group was given these permissions. The proposed name of this group is "PeopleSync Admins", but you may have named it differently. Please add all users running PeopleSync console to this AD group.
In case the group is missing, please check in SQL Server Management Studio, if an admin group was given permissions for the PeopleSync database. To do this, in SQL Server Management Studio, navigate the tree on the left the PeopleSync database, and then to Security\Users. It should look similar to this:
If you used a different group during setup, you should see your admin group instead. If it is there, please add your user to this group in AD. Then logoff/logon and try to open PeopleSync console again.
If there is no PeopleSync admin group, please create one in AD. Then, do as follows to assign permissions in SQL Server:
In SQL Server Management Studio, go to the tree in the left-hand side. From top level, go to Security\Logins.
Open context menu and select "New Login".
For "Login Name", select your AD group. Also select "Windows Authentication" and set "Default Database" to the PeopleSync DB.:
Go to "Securables" and select the PeopleSync database. Then select db_datareader and db_datawriter permissions:
Save.
Add your user to this AD group, logoff/logon and try opening the PeopleSync console again.