08 January 2009

Win 2008 SBS and Quickbooks

Some of my clients and our business use Quickbooks (QB). Here in Australia, we seem to be a version behind the US release, as the local franchise applies the relevant localisations. In May 2008 I contacted their help desk about support for x64 systems. They only just released support for Vista (32bit) and told me that there was absolutly no 64 bit support. I tried it, but ended up corrupting my company file, which caused me a lot of grief.

In August 2008 Quicken released Quickbooks QBi 2008/09. This version has got a server database engine, although it is not clear what it exactly does. I contacted the support desk again, and they indicated that they still don't support x64. Bad news as Windows 2008 SBS is only supported on the 64 bit platform. Quicken encouraged me to try the server component on x64, but of course, they would not be able to give us any support...

In the meantime I have installed Win2008 SBS on one client site with Quickbooks and I am about to install a second site. This is what I did to get it working:

I googled and found this article on Sue Bradley's blog (great site, btw; a must for SBS admins). The above quoted article refers to the US 2008 version, so I still had issues. I chatted with Imran from the local help desk, who dug up another article for me that clarifies what is required for the local 2008/09 version (which equates to the US 2007 version):

The following files must be granted access through the firewall on Port 10172 for both Incoming and Outgoing Traffic: FileManagement.exe, QBDFMonitorService.exe, QBDBMgr.exe, QBDBMgrN.exe, QBGDSPlugin.exe, QBW32.exeQBUpdate.exe

See Quickbooks KB Article 203312

Sue's article mentioned above makes reference to the DB service "qbdataserviceuser18" (US 2008), which in our AUS release is only "qbdataserviceuser17", so the relevant adjustments must be made.

For the firewall I simply added new rules in the Windows 2008 Advanced Firewall applet. I only created 2 port rules without specific rules for the various executables. If you are very security conscious you should probably do it tight. Time permitting I might create a script for the firewall rules to fix this. I then had to re-scan the DB folder for company files and all was working.

There was another little annoyance. When I wanted to use the Quickbooks DB manager, I clicked the bright red icon, that the QB install routine plastered on the desktop. Nothing happened. After some head scratching I found out that it can be deleted. The DB manager has a different icon, which can be found via the start > programs hierarchy.

Update - May 2009

Two client sides have been using QB Enterprise 2008/09 now for a few months and we have had no issues, so I assume the above patches and settings work long term!

No comments:

Post a Comment