Why am I getting ODBC Driver 17 Access rights error after upgrading SES?
Problem Scenario
After recent upgrade to 8.2 SR1, client is noticing that when trying to login to the console, noticing the following error message occurs:
Error Message:
37000:[Microsoft][ODBC Driver 17 for SQL Server][SQL
Server]xc_reg_read() returned error 5, 'Access is denied.'
Example:
After clicking on OK, the error disappears and admin user is able to continue
Environment:
SecureDoc Enterprise 8.2 SR1
SecureDoc Enterprise 8.2 SR1 HF1
Cause:
Due to a recent issue identified in which is observed after upgrading SecureDoc to either 8.2 SR1 or 8.2 SR1 HF1, some environment did not perform a successful store procedure update within the SES Database table.
Proposed Solution:
Attached to this article is a SQL Script which will complete the necessary changes in order to update the “store procedure”. Once this store procedure is executed, the ODBC error 17 should no longer occur.
Please run this SQL script against your SES Database.
Internal: SD-27636