Thursday, January 10, 2013

QuickBooks error -6123, 0, and my solution

I was troubleshooting error -6123, 0 with QuickBooks Pro 2008, finally solved the problem and thought I'd share.

The text of this error message was something to the effect of "cannot connect to database server," however, mine was a single user installation with the company file residing locally. I realize QuickBooks may use a database server to connect to even a local database, but the knowledge base article on Intuit's website for error -6123, 0 was aimed at situations that did not apply to me. I was not using the company file over the network, I was not in multi-user mode, nor was I restoring a backup.

I went through a bunch of things, including the use of the QuickBooks File Doctor, which said my database was perfect. I disabled Windows firewall, and was using no other. I restored a backup of the company file using Windows Previous Versions. I checked QuickBooks services but found nothing that jumped out at me. I was stymied.

I started thinking about how I had the system set up. The computer is joined to a domain, so I logged in as Domain Administrator, tested QuickBooks, and it worked. The user I have set up to use QuickBooks doesn't have local admin, and I'd rather avoid giving it to her if possible. So I started Googling and ended up finding another Intuit knowledge base article for "Configuring multi-user access requires Windows Admin rights". Even though I'm not in a multi-user scenario, I decided to see if the information was helpful anyway, and it turns out it was.

Solution: For QuickBooks Pro 2008, there is a Windows user account called "QBDataServiceUser18" which I added to the local Administrators group. That did the trick and now my user can access QuickBooks without that pesky error anymore, and without admin rights!

18 comments:

  1. Hi.

    I had the same issue. I have added my QBDataServiceUser17 to the administration group but this did not resolve my issue.

    When I tried to open Quickbooks Database Server Manager is stated that I need to turn on hosting (Open Quickbooks and click File, Utilities, and then click Host Multi-User Access). When I opened this, it already stated that the Multi-User access is enabled, do I want to disable it? I then chose yes to disable and once it was disabled, I was able to open my quickbooks again.

    Just thought to share my situation and how I have solved it.

    ReplyDelete
  2. My issue was that the service QBCFMonitorService was stopped. I just had to start it up and it was fine. Happened after upgrading to windows 10.

    ReplyDelete
  3. I am running QB Pro 2016 on a Win10 workstation with Win Defender as the malware/antivirus software. I went into Defender and excluded the .QBW file plus the Intuit folder from Defender, Voila! I am now able to get into my QB company file! If you are running McAfee, you should be able to do the same exclusion.

    ReplyDelete
  4. Quickbooks additionally gives you a chance to print out checks from various financial balances so that you'll never need to request checks from your bank office again. The product additionally empowers a business to monitor its stock to all the more productively deal with its inventory network.
    http://phonenumbersupport.com/quickbooks-support-number/

    ReplyDelete
  5. Had the same error, with the message to the effect that "could not contact the database". I am also running QB in single-user mode with the company file on the same drive as the QB application. I solved my problem after spending 1/2 day on it!

    I attribute the solution to one of two things (or both). I saw an article in the intuit user forum about renaming the "nd" file (network file) associated with the company file. I did that but still had the error. Then I opted to reinstall. Step 1 to reinstall is to uninstall the existing version of QB through Control Panel. It would NOT uninstall because it said the application was open (but I had closed it). Task Manager showed be several QB associated files open, which I closed through Task Manager. It occurred to me that this error was occurring because QB somehow believed I was in multi-user mode when I was not, and that there may have been another instance of QB running. Also suspecting that the shortcut from the QB open dialogue may be corrupt, I then located my QB company file and right-clicked to open the file with QB. Voila, success! It could have been the rename of the "nd" file. It could have been closing down all QB files in Task Manager. It may have been both.

    I have another company file that was giving me the same error. I will report further if there is anything different.

    ReplyDelete
  6. Not having the same good fortune with my second company file. One step I neglected to mention above was that I had run Quickbooks File Doctor on the file I eventually successfully opened (but the Doctor did not appear to solve the problem). I ran the same utility on the second company file and it is reporting that this second company file is corrupt and irreparable. I'm on a different track to fix it. I am pondering how the problems with the two files could have occurred. I notice that the database manager and Intuit personal database manager are starting as background services registered in Task Manager, though I am not running in multi-user mode. On one occasion tonight, there were two instances of database manager running. I'm not sure that any database manager should be running and the answer to that question does not seem easily answered.

    ReplyDelete
  7. will you tell me that how to install this software thanks :) QuickBooks Pro 2015

    ReplyDelete
  8. will you tell me that how to install this software thanks :) QuickBooks Pro 2015

    ReplyDelete
  9. Call for Virtual Bookkeeping, Accounting & Payroll Services? DATA Services Usa is here to provide high quality services to Small and Medium-sized businesses. For more info:- http://accountingdataservice.com/bookkeeping.html

    ReplyDelete
  10. Affordable, QuickBooks certified bookkeeping services focused on building and maintaining long-term partnerships with our clients. Call us-1-844-777-1902, Get More Detail- http://accountingdataservice.com/bookkeeping.html

    ReplyDelete
  11. Need Bookkeeping Services for Your Growing Business? Is it accurate to say that you are prepared to discover somebody who can basically deal with the greater part of your accounting needs so you don't need to? Call Us-1844-777-1902. More info: - http://accountingdataservice.com/bookkeeping.html

    ReplyDelete
  12. Invoice processing services, we can handle all your invoice processing needs and accurately capture required data from invoices. Our Support is accessible 24×4 and 365 days to give you quality specialized help to all you QuickBooks issue. Call us-1844-777-1902. Get More Info: - http://accountingdataservice.com/invoiceprocessing.html

    ReplyDelete
  13. Need Bookkeeping Services for Your Growing Business? Are you ready to find someone who can simply handle all of your bookkeeping needs so you don’t have to? Call Us-1844-777-1902 and More Info:- http://accountingdataservice.com/bookkeeping.html

    ReplyDelete
  14. DriverMax Pro 9.43.0.280 Crack Full Free Download
    A decent post, extremely grateful and cheerful that you will compose numerous more posts like this one.
    Keep it up for more valuable sharing. Well thank u so much.Thanks for share this informational post, This is very helpfull article.

    ReplyDelete
  15. Thanks for Sharing such a helpful post. I am also a Bookkeeper and had faced this error. Generally QuickBooks Error code -6123, 0 is one such error. There might be multiple reasons for this error to occur. With the help of Article i have fixed my error.
    Source: How to Fix QuickBooks Error code -6123,0

    ReplyDelete
  16. Thanks for the post, recover the all issues QuickBooks with QuickBooks file doctor @ toll-free number with best reasonable prices with best support services

    ReplyDelete
  17. 300-175 exam braindumps test4actual.com provide latest and updated braindumps with Actual Exam Questions & Answers for new syllabus of Cisco 300-175 Exam.

    ReplyDelete