1. Home
  2. Point-Of-Sale Software
  3. Please Help!!! Error Connecting POS to MS Office Accounting

Please Help!!! Error Connecting POS to MS Office Accounting

I have just installed MS POS 2.0 on my machine which will serve as my register. I have MS Office Accounting 2007 installed on another computer. I am now trying to integrate the two together and am receiving the error message "Could Not Connect To Office Accounting 2007".

I have set Accounting up for multi-user and I have run the Office Accounting Integration on the Office Accounting computer. I've set the password (and double-checked it). I can browse to the file in POS. POS properly displays the computer name and the company name. I click 'Next' and get the prompt to enter the password and after I click 'Next' again, that's when I receive the error described above.

Does anyone have any idea what I can try next? I'm not even sure where to begin since the error message isn't very descriptive. Any help that you can give would be GREATLY appreciated.

Thanks in advance!

Reply to
Ruiner
Loading thread data ...

One thing that did occur to me last night that I haven't check out. I set the password in the Accounting machine and then used the same pass on the POS machine, however, that is not the same pass as the one used to open the company file directly from within Office Accounting.

Does the password that is used in the Remote Accounting Setup have to match the password for the company file?

-R

Reply to
Ruiner

I can tell you that i had lot of issues with the Remote Accounting setup. Here are a few things i ran into, and how i was able to fix the issues:

To begin, right out of the box for one of my customers, i was able to get the remote accounting working and synchronizing using XP Pro on the main DB machine. I had Vista Basic installed on the backoffice machine that had SBA

2007 installed.

Everything worked fine until:

I installed SP1 for POS and SP1 for SBA2007 and it broke the integration.

I had a ticket open with MS, and they have a bug report open with Vista and XP working together. They recommended installing SBA and POS on the same machine which i didn't want to do because we need to access SBA2007 from the backoffice while orders are being taken on the POS machine.

I then moved SBA 2007 to an XP Pro machine, and ran into the same problems that you are having with "Unable to Connect".

I ended up having to backup my database. Uninstall everything...reinstall everything according to the setup guide, restore the database, apply service packs first for both POS and SBA2007 and then complete the integration again which finally worked.

It was a large inconvenience i must say. There are a few bug reports open with microsoft so they are aware of the issues.

I must say that the POS group at microsoft is very, very helpful. > One thing that did occur to me last night that I haven't check out. I set the

Reply to
ABH Development

I figured it out! OK, the issue was that apparently underneath, the synchronization process uses the Guest user account that's built in to Windows XP. However, my version of XP Pro had this account disabled. I was able to track this down by looking through the event log. I enabled the Guest account and my integration went perfectly.

Hopefully this will help anyone else who runs into the issue.

-R

Reply to
Ruiner

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.