I get the following message in QuickBooks Server Manger on the Database Server tab:
"Unable to retrieve connected files and logged in user list." We can see all the QuickBooks files on the first tab when we scan the directory. We also have the drive selected under the scan drives tab.
Also, when we have the second user try to connect to the QuickBooks data file on the server, we get:
"Quickbooks was unable to ope the company file <file location> on the host computer <server name>. Try opening the file with QuickBooks on the host computer or run the QuickBooks Database Server Manager on the host computer...
Error Codes (-6190, -816)"
We are running a Windows 2008 Server. That is where the QuickBooks data file is located. All the computers trying to access the server data file are using mapped drives. The file was just converted from 2006 to 2008. Any one workstation can access the file without a problem.
I have tried deleting the secondary QuickBooks files that get created and rebooting the server. QuickBooks support was also of very little help so far. The articles they sent me either did not address my issue or didn't work. Any suggestions would be appreciated.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Thank you for your prompt response.
I will try the software on our 2003 Server tomorrow, to see if 2008 is the problem. I tried moving the database files to the same directory where the QuickBooks program files reside - Same problem.
QuickBooks is not running in Host mode on any of the computers and I only have 2009 Server Manager installed.
I spent a good deal of time on the phone with QuickBooks Support today. I started the conversation with, "Is QuickBooks Pro 2009 Server Manger compatible with MS Windows Server 2008 x64." They first said no, but they believe that the Premier Edition will work. I would just need the license key to unlock it. I explained that would make little sense, since it was the same code/application. Then they told me that QuickBooks Enterprise is tested and will run under MS Windows Server 2008 X64. I explained it was unreasonable to expect me to pay $2500 more to work around the problem, which they should fix.
They did not have any time frame for fixing the issue, but said it was being worked on. In the mean time, I have moved the data to a Windows 2003 Server OS.
You will still get that error message on the server but by disabling the server firewall, giving full rights of the Quickbooks files to the user 'QBDataServiceUser1x', I've been able to enable multi user mode in a SBS 2011 environment.
Instead of disabling the firewall you can open the appropriate ports:
10180, 80, 8019, 56719, 55333, 55334, 55335, 55336
Also remove the Quickbooks program and data folders from real-time scanning within your AV program.
Any or all of thewse should resolve your problem.
Business Accounts
Answer for Membership
by: thinkpads_userPosted on 2009-03-26 at 15:31:56ID: 23996359
I asked Intuit if the Server Manager was supported on Windows Server 2008 and could not get a clear answer. I have that potential issue coming up, but it could be a few months off.
You need to have (or at least should have) the Ledger and its transaction log and associated files in the same folder and on the same server drive that Server Manager was installed in. You cannot install Server Manager in drive C: and keep the ledger on drive D: Check that (although you probably already have done this).
Make sure your QB clients are not running in HOST mode (you can turn that mode off). This will not affect the ability of server manager to scan.
Finally, you need to use the Server Manager from QB 2009, not a prior version.
... Thinkpads_User