Unable to Connect - PeopleSync Console

Owned by EBERHARD, Sebastian (messageconcept), created
Last updated: Apr 08, 2021
3 min read

Problem

When opening PeopleSync Console, the following error message is shown:

Error Message

The application cannot connect to the specified database, because the latter doesn't exist or its version is older than that of the application.

This error occurred because the automatic database update was disabled when the application was started without debugging.

To avoid this error, you should either start the application under Visual Studio in debug mode, or modify the source code of the 'DatabaseVersionMismatch' event handler to enable automatic database update, or manually create a database using the 'DBUpdater' tool.

Anyway, refer to the 'Update Application and Database Versions' help topic at http://www.devexpress.com/Help/?document=ExpressApp/CustomDocument2795.htm for more detailed information. If this doesn't help, please contact our Support Team at http://www.devexpress.com/Support/Center/

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: 

  1. In SQL Server Management Studio, go to the tree in the left-hand side. From top level, go to Security\Logins.

  2. Open context menu and select "New Login".

  3. For "Login Name", select your AD group. Also select "Windows Authentication" and set "Default Database" to the PeopleSync DB.:

     

  4. Go to "Securables" and select the PeopleSync database. Then select db_datareader and db_datawriter permissions:

     

  5. Save.

  6. Add your user to this AD group, logoff/logon and try opening the PeopleSync console again.

Related articles

© 2010-2024 messageconcept GmbH / messageconcept software GmbH
Legal Notice / Imprint