E-AD: Getting "File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 8076 - Invalid SNAC client version" Error Logging into Application Designer Using a User's Admin Account
(Doc ID 2959505.1)
Last updated on OCTOBER 04, 2023
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.49 and later
Information in this document applies to any platform.
After using an individual's Admin account to connect to the Application Designer client machine, attempting to log into Application Designer with the local admin account returns the error below.
However, connecting to the Application Designer client machine and Application Designer with the service account is successful.
The issue remains even though the customer exported the service account's PSCFG configuration, and imported it into the local Admin account.
"File: SQL Access ManagerSQL error. Stmt #: 2 Error Position: 0 Return: 8076 - Invalid SNAC client version (minimum is 09.00.2047) (SQLSTATE PS076)"
PeopleToools (PT) 8.49.23
Microsoft SQL Server Database
Steps to Replicate:
1. Log into the Application Designer client machine with the Windows local account and attempt to log into Application Designer.
2. Observe error shown above.
3. Now, log into the same Application Designer client machine using the service account and attempt to log into Application Designer.
4. Observe that the Application Designer login is successful.
Access to the Application Designer client machine (remote server) changed from the service account to the Windows User Account.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document