Over the weekend, we applied the updates on our 2008 R2 Standard server. This server is a virtualized machine. We use this machine to run our QuickBooks Database Manager software and store the quickbooks file.
After rebooting server, we can no longer open any of our QB files. All services come up normally. However, if any client workstations opens any QB file, the QuickbooksDB23 service immediately stops and the client starts receiving a variety H202 errors or (-6000, -301). This makes sense since that this point, the Database manager service is no longer running.
I contacted support who completely uninstalled the server manager from the server, ran their "clean up" tool, reinstalled the entire application including the front end and tested again with the same error and result. We even tried to open the file from the server directly and it didn't work. It doesn't matter if you try to open the file in single user or multi user mode. The application does allow you to put in credential for the QB file so it doesn't immediately crash the service until after you try to authenticate. (I am logging in as admin in the file).
Their resolution was that QB is not support on a VM because it's too unstable. The work around was to copy it to a local workstation and open it in multi user mode there. For whatever reason, that worked and they want QB to be on physical server not a virtualized one. This install of QuickBooks has been installed on this server for at least 2.5 years and has been on several versions of Enterprise without issue.
My guess was that it was due to a MS update that came down. I uninstalled each patch that was applied (and for the most part had to restart the server in between each patch), tried it again in between each patch removeal and it still didn't work. All of .NET 4.5 is off of the server. I've attach a list of patches that I removed from the weekend update.
The following error keeps getting logged each time someone tries to open the file. I have researched this thing to death and I can't seem to find anything regarding this issue. What support told me is that the QB service is trying to make a registry entry each time someone opens the file and is getting denied (which didn't make sense to me). However, I dropped the local Quickbooks account it creates in order to run the QuickbooksDB23 service in to the local administrator group on the server and tried it again but it's still the same error.
Right now the file is still loaded on a workstation. I was wondering if anyone can help me with this error. I have no idea what SQLANY has to do with QB or how to correct this.
Log Name: Application
Source: SQLANY 11.0
Date: 2/16/2015 6:21:22 PM
Event ID: 1
Task Category: None
The description for Event ID 1 from source SQLANY 11.0 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
*** ERROR *** Assertion failed: 100904[1bb5ff83bcf04b159c0
Failed to redo a database operation (id=4, page_no=0x575f5, offset=0x7dc) - Error: Cannot access file 'C:\Users\
<Provider Name="SQLANY 11.0" />
<Data>*** ERROR *** Assertion failed: 100904[1bb5ff83bcf04b159c0
Failed to redo a database operation (id=4, page_no=0x575f5, offset=0x7dc) - Error: Cannot access file 'C:\Users\</Data>