Applies to: Any PACS integration where Data Manager reads directly from a SQL Server database
Symptom: A sync fails with an error similar to:
The SELECT permission was denied on the object...
Root Cause #
The Data Manager service account does not have SELECT rights on a table it needs to read. This most often appears after a schema change or migration — for example, a PACS version upgrade that adds a new table, or a database migration to a new SQL Server instance where permissions weren’t fully carried over. The account may have worked fine for months before this, so it’s easy to mistake this for a new bug rather than a permissions gap introduced by a recent change.
Fix #
- Identify the exact table named in the error text (or work with your DBA to trace which table the failing query targets).
- Confirm the Data Manager service account has SELECT permission on that table.
- If you recently upgraded your PACS or migrated the database, check whether the migration/upgrade process added new tables that the service account’s permissions weren’t extended to cover.
- Grant the missing permission and re-run the sync.
This typically requires your database administrator or PACS administrator, since it involves SQL Server permission grants rather than an XPressEntry-side setting.
If This Doesn’t Fix It #
- Confirm you’re granting the permission on the correct database/instance if there is more than one in your environment.
- Check for any other permission errors later in the sync log — sometimes more than one table is affected after a migration.
- Contact the Telaeris Helpdesk with the exact error text and which table it references.
