Hello Quickbooks Network Experts -
We have a working multi-user Quickbooks 2014 environment with Company Data files being served by a Windows XP machine running only the database manager with the files in a network share. All QB workstations are W8. For obvious reasons we want to retire the XP machine. The only reason we have it is when we bought Quickbooks in 2011 the database manager would not run on our ancient Windows 2000 SB Server.
Now that W200SB Server is history. We are running Windows Server 2012 Essentials R2 in it's place. We also plan to upgrade to QB 2015 which does not support XP as a database manager. I attempted to migrate the data files to a share on our 2012 server. I installed the database manager from QB 2015 in anticipation of our upgrade. I did have some problems with the QB install as it didn't seem to like the server version of .Net, but eventually I got a good install.
All went well with my test using a W8 client and a QB 2015 client install. A few days later I moved the live data to W2012 and attempted opening 2014 files from the new share on 2012. This worked fine with a user who was in Single User mode, but as soon as a user tried to access a file in Multi-User mode they got a H202 Error message that the 'host is not set up for Multi-User access'. Then the user who was able to access files tried changing to Multi-User mode and got an H505 complaining that the 'location needs additional set up'.
We have a support contract with Intuit so I called this in. They said I can't serve 2014 files with a 2015 DB manager and suggested reverting to the 2014 version of the DB Manager. This made no sense to me as 2015 can't connect to the 2014 manager, so how could 2014 files be upgraded to 2015 (rhetorical - don't answer :) ?
I humored them and did what they asked - Stopped the QB Sservice, Uninstalled QB DB Manager 2015 and installed QB DB Manager 2014. As I suspected, it made no difference. Same errors at both stations.
Unable to keep my accounting department off-line for any more time I reverted back to the XP hosted DB Manager and all was well.
So here are the questions ---
1. Are they correct that the 2015 (Version _25) of the DB Manager can not host 2014 data files in Multi-User Mode?
2. Is the 2014 (Version _24) of the DB Manager compatible with Windows Server Essentials 2012 R2?
If answer #1 is No OR #2 is Yes, why then did I fail?
If you were planning this migration what would your steps be?
Should I copy only the .QBW files to the new location and let the QB re-build the rest including the search folders?