Solution Properties
Solution ID:
222924750022587
Last Modified Date:
Tue Jun 22 17:56:06 UTC 2021
Taxonomy Path:
Category//Setup and configuration
Author:
LegacyAuthorUS
Error: "Pervasive Status Code 171"
Description
Cause
  • The Pervasive/Actian/Zen SQL database engine runs as a service and uses the local System account by default. The local System account usually does not have access to data on another server.
  • The Use Cache Engine option is checked in Pervasive Control Center/Zen Control Center and the Pervasive/Actian/Zen service is using the Local System account.
Resolution

Modify the Pervasive/Actian/Zen service to log on as an Admin user

Contact your system administrator if you require assistance.

 

Domain:

  1. On your keyboard, press Windows key + R
  2. Type: Services.msc
  3. Click OK
  4. Right-click the Pervasive/Actian/Zen service
    • Example: Actian PSQL v12 Client
    • Example: Pervasive PSQL v11 Workgroup
  5. Select Properties
  6. Click the Log On tab
  7. Select: This account:
  8. Enter the DOMAIN\ADMINISTRATOR account and password
  9. Right-click Pervasive/Actian/Zen service and select Restart

Workgroup:

  1. Create a local admin account on the workstation that is identical to the local Admin account on the server (same user name and password).
  2. Add the new local admin account to the Actian service on the client.
Steps to duplicate
Related Solutions

Error: "This program has quit. I/O Error. Pervasive status code 171" (workstation not on a domain)
Sage 300 Construction and Real Estate and Sage Estimating Required Windows Permissions