Peachtree Database error Windows Server 2008 RC2

Sage 50 Accounting U.S.

Sage 50 Accounting U.S.
Welcome to the Sage 50 Accounting U.S. edition product support community! Here you can ask questions, discuss the product and share best practices with other Sage 50 U.S. users.

Peachtree Database error Windows Server 2008 RC2

  • Hi!

     

    I work for a small print shop, and we have Peachtree installed on several of our computers, varying from Win 7, Win XP, to Server 2008 RC2. Peachtree works on the majority of these platforms, however we have been experiencing a database error on the server 2008 machine. The Server 2008 machine is also the computer that holds the company information for Peachtree. I have been browsing these forums for help since I started in November. I have modified the registry keys for the "truncated file name" fix in hopes of being able to point Peachtree towards the correct folder with the truncated file name. I have done several re-installs, which does allow seeminly temporary access to peachtree, but eventually I get the same error claiming there is a database error, restart your computer to fix this problem. It is becoming rather frustrating to have to spend the 15-20mins uninstalling then reinstalling the software for it to work on this station, which also puts the other users out for the same time untill Pervasive is reinstalled.

     

    Any help is certainly appreciated, I am willing to try anything, and do have a good understanding of how computers work, and am confident in completing any type of solution(ie registry editting, file permissions, firewall exceptions etc).

     

    Please help! This does seem like an active community so I do look forward to trying to come up with the answer! Thanks!

  • Windows Server 2008 RC2 ( pre release candidate 2 for the original 2008 server) or Windows Server 2008 R2 (latest Windows Server version)?

     

    Big difference. You should not be using RC2. It was only for testing and is not supported.

     

    What version of Peachtree are you using?

  • Thanks for responding Howard!

     

    My mistake it is Windows Server 2008 R2 Standard Edition.

     

    We are using Peachtree Accounting 2011.

     

    Any  help from here would be greatly appreciated!

  • Three items to start with:

     

    1. What are the error messages, which machines have the errors  and when do you get the errors?

     

    2. Have you done all the Microsoft and Peachtree updates including on the Server and including the non critical Microsoft updates?

     

    3. Is the server a domain controller with AD, DHCP, and DNS running?

     

     

  • None of the services are running, Active Directory, DNS or DHCP, on this machine. Any ideas?

     

    Oh, and yes, all updates to both Server 2008 and Peachtree have been installed.

     

    The error message received is "The Peachtree database engine has encountered an error. To correct error, please restart

     your computer"

     

    Which I have done, several times, only once did a restart work. As I mentioned previously, restarting the computer is not a preferable solution as other users access the peachtree database through this computer (and they have not encountered any errors with the database.)

     

    Sorry for the late reply. Thanks!

  • Did you run Microsoft Update on all the workstations?

     

    Everything would work better if you had the DHCP, DNS and AD working. Since you do not, you are missing the services that help windows programs to find the resources on the network that they need:

    Mainly you will need Microsoft's services that find stuff in such networks (peer to peer networks).

     

    Microsoft has services that allow the Workstations on the peer to peer network discover and communicate with each other. Here are some articles about these services (Microsoft Link-Layer Topology Discovery services - LLTD):

    http://technet.microsoft.com/en-us/library/409fb2fa-8eb8-45af-b063-4f50f5a77b29

    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=5577

    http://support.microsoft.com/kb/922120

     

     

     

  • Wyattmckenzie,

     

     

    I stumbled upon this post when I had the same issue. My situation is almost identical to yours, except server 2008 R2 is our cloud environment and all users remote into the same workstation to use peachtree.

     

    Still, the fix couldn't hurt to try.

     

    Uninstall Peachtree on the Server 2008 R2 box. Make sure you remove everything, including the pervasive peachtree items under add/remove programs. Restart the server before you reinstall.

     

    When you reinstall, go to control panel > Remote Desktop install mode

     

    Run the installer from there. It solved our problems :smileyhappy:

     

    Good luck!