• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1964
  • Last Modified:

Peachtree Pervasive Workgroup/ Pervasive Client/Server get error 170

Customer has latest Peachtree Quantum. To simulate I downloaded and installed on a Domain server and 1 workstation. I used the .bat file supplied for the workstation.

Peachtree runs fine.

My app did use wbtrv32.dll for the client but it did not work. Switched to w3btrv7.dll and it did work as long as the other server where my app was running had Perv 11 32 workgroup.

Tried both 32 bit and 64 bit Perv 11 Trial Server on the server holding my app and not the Peachtree app from the single workstation and got error 170. Login needed.

Is it possible to have Pervasive Server on a different server where Peachtree is not installed and be able to launch both Peachtree account AND my app on the same workstation as long as user limits would not be exceeded.

1 Solution
Bill BachPresidentCommented:
The status 170 is probably coming from the Client Cache Engine, or CCE.  When PeachTree installs, it installs the Workgroup Engine as a service.  BY default, this service is granted "Logon As" account as "Local System".  This Local system account has full access to the database engine locally, as well as on other Workgroup Engines (which do not enforce OS security).

When you use a Server Engine, which DOES enforce OS security, this lcoal system account doesn't have enough access.  To fix this, go into Services and find your PSQL Workgroup Engine in the list.  Right-click/Properties and go to the LogOn As tab.  Change the account being used to a domain account -- one which DOES have rights to the server-side data.  Once this is done, you'll be home free.
bob_mechlerProgrammerAuthor Commented:
Well explained. Complete. Should have thought of this myself. Makes total sense since the same app works fine directly on the server after logging in with a domain login.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now