Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
DMD6
Level 1

Quickbooks Enterprise 2024 Asking for Windows Admin Credentials

I currently have an RDS server deployed running Windows Server 2022 with QuickBooks Enterprise 2024 installed. I have about 10 users who RDP into the server daily to use QuickBooks. We have about 10 different company files stored on a local drive on the server. Everything has been working great up until recently, when users began notifying me of a message that pops up when opening the QuickBooks program prompting for Windows Administrator credentials. If they hit cancel, it does not allow them to open any company files. I need to either remote in and provide the admin credentials, or restart the server. Both of those options seems to 'fix' it temporarily for about a week before the message comes back. It gets tedious having to do that frequently and halts our accounting department until I fix it, and I am not always near a computer to fix it remotely if I'm not on site. I have scoured other forums and tried many different solutions that worked for other people but none have worked for me. I have changed the 'QuickBooksDB34' service to run as a local service which breaks QuickBooks even more. I have checked folder permissions and verified that the QB user had full control permissions on the folders where the company files are stored. All users have the correct permissions on the folders as well. I do not want to entertain making all my users administrators on the RDS server as that would be a security nightmare to manage. I have gone deep in the weeds and tried to create a batch file that restarts the service on user login but that too has failed. Any ideas or help would be greatly appreciated.

Capture.PNG

IMG_9765.jpeg

12 Comments 12
GenmarieM
QuickBooks Team

Quickbooks Enterprise 2024 Asking for Windows Admin Credentials

I appreciate the actions you've taken so far to resolve the error, DMD6. I've got steps so your users will not be prompted with a permission error when opening QuickBooks Desktop (QBDT).

 

The error messageThis action requires Windows administrator permissionsindicates that your current user account lacks the necessary privileges.

 

First off, ensure the access folder is in multi-user mode and that the correct Windows permissions are set. To view the summary of the restrictions configured for a user profile, click on the user and then select View User.

 

To verify the permission is configured correctly, follow these steps:

 

  1. Open the Windows Start menu and then open File Explorer.
  2. Right-click on the folder that contains the company file, then select Properties.
  3. In the Properties window, go to the Security tab and select Advanced.
  4. Choose QBDataServiceUserXX and click Edit.
  5. Set the following settings to Allowed:
    • Traverse Folder/Execute File
    • List Folder/Read Data
    • Read Attributes
    • Read Extended Attributes
    • Create Files/Write Data
    • Create Folders/Append Data
    • Write Attributes
    • Write Extended Attributes
    • Read Permissions

 

If your permission isn’t correctly set, follow the steps below:

 

  1. Right-click the folder that carries the company file.
  2. Go to Properties, then select Security and Edit.
  3. Choose QBDataServiceUserXX and then click Full Control.
  4. Press Allow.
  5. Click Apply, and then press the OK button.

 

For more detailed steps, check out this article: Set up folder and Windows access permissions to share company files.

 

If you are still experiencing difficulties after completing the recommended steps, consider seeking assistance from an IT specialist. Their specialized skills can help identify and address the underlying problem.

 

Moreover, you can utilize this article for future use if you want to back up your accounting data: Back up your QuickBooks Desktop company file.

 

Let us know if you have additional concerns or questions about accessing your company files in QuickBooks Desktop. Our team is always here to offer help.

DMD6
Level 1

Quickbooks Enterprise 2024 Asking for Windows Admin Credentials

Hello,

 

Thanks for the follow up. I have already made sure that the 'QBDataServiceUser34' had full control permissions on the folder where the company files are located. The problem still remains and it only happens every 3-5 days or so. The only way I can get it to work again is to logon with Windows Administrator credentials to clear the UAC prompt, restart the 'QuickBooksDB34' service (required Windows Admin credentials), or I have to reboot the server (any of these fixes it for only 3-5 days). Again, these are not ideal solutions as I am not always near a computer where I can help my users when they need it, and therefore, they are unable to use QuickBooks until I am able to login and perform one of the above listed "fixes". It is happening far too frequent and is becoming a nuisance to me and my QuickBooks users. Please let me know if you have additional ideas or troubleshooting steps. Thank you.

JaeAnnC
QuickBooks Team

Quickbooks Enterprise 2024 Asking for Windows Admin Credentials

It's concerning when the issue has been recurring for an extended period, @DMD6. I'll point you in the right direction to resolve the error prompt received by your users in QuickBooks Desktop (QBDT).

 

Since the issue persists after performing the suggested troubleshooting, I recommend reaching out to our customer support team. This way, they can look into this further and walk you through the resolution. They can also initiate an investigation if need be.

 

To do that:

 

Go to the Help menu and click QuickBooks Help.
Select Contact Us.
Provide a brief description of your concern, and click Continue.
Log in to your Intuit account, select Continue, then Continue with my account.
Enter the single-use code you received in your email and hit Continue.
Choose between Chat with us or Have us call you.

 

Furthermore, you can refer to this article to manage your users in QBDT: Create and manage users and roles in QuickBooks Desktop Enterprise.

 

You can ask us anytime whenever you have further concerns regarding user permissions. We'll always be available to help you out. Stay safe.

CodeJericho
Level 1

Quickbooks Enterprise 2024 Asking for Windows Admin Credentials

Hello DMD6,

 

Where you able to resolve this issue?  I had the same thing happen and it turned out to be a problem with the shortcut being used to launch QuickBooks.

 

I had copied a shortcut from another computer to our RDS server and not realized that Windows "helpfully" turned the path into a UNC path back to the computer I had pulled the shortcut from.

 

Original shortcut Target: C:\Program Files\Intuit\QuickBooks Enterprise Solutions 23.0\QBWEnterpriseContractor.exe

 

After copy/pasting the shortcut, Windows had changed the Target to:

 

\\computername\c$\Program Files\Intuit\QuickBooks Enterprise Solutions 23.0\QBWEnterpriseContractor.exe

 

Launching that shortcut caused QB to give me the same prompt asking for Admin privileges.  After change the shortcut back to the correct local path of C:\Program Files\..... the Admin prompt went away.

 

I hope this helps.

ASPC
Level 1

Quickbooks Enterprise 2024 Asking for Windows Admin Credentials

Quickbooks support will not help you fix this. In fact, several years ago, they made it worse for us. I've had this issue for years, and yes it is a sever security concern. We have had all kinds of issues every year at this time, and here we go again with more, including this one (QB problems cost us hundreds of hours every year. It's so common for years now that the time expense talking to QB support and working though our many problems every year is a line item in our financial reports). This particular issue we resolved by keeping the QB machines in each their own DMZ with limited internet access, keeping an image of the system drives in case they get compromised and made the users administrators. Now these computers don't connect to the internal Corp network. They only work on files from flash drives, one at a time and the users sneaker-net them back to their internal Corp machine and copy them back to the server when done. This saves me about 100 hours each year fighting with QA Support agents who have no clue what they are doing (that's $20,000 for "Quickbook Support Costs"). The extra time the bookkeeper spends is actually negligible, about 15 minutes per file, and that gets billed. The QB customer assistance team made this issue worse a few years ago, which is why we now have our workstations in their own isolated DMZs, problem solved! So again, the solution to this issue is to 1- buy a cheap used office computer ($300). 2- Install all your QBs on it. 3- Create a DMZ on your network for each computer sitting off the edge of your gateway. 4- Make a disk image in case the computer get compromised. 5- Make the users administrators on those machines. 5- When they need to work on QB 20-21-22-23-24 Desktop files, they copy the file (folder) from the server to their main local workstation on the Corp network, mark the client folder as "Checked out" on the server, copy the folder onto a flash drive, swivel their chair, plug it into the DMZ machine and when done scan the flash drive for issues, swivel back, copy the folder back to their workstation (which gets scanned again), upload to the server and mark the folder "Checked in". Problem solved, saves time and money, and the aggravation of working with the QB support team which usually makes matters worse.

DMD6
Level 1

Quickbooks Enterprise 2024 Asking for Windows Admin Credentials

Thanks for the feedback. Thats really unfortunate the lengths you have gone to get things to work. Unfortunately for me, I have about 12 people that share the same company files in multi-user mode so it would be very difficult for me to implement a similar solution. Thanks for posting!

yebe
Level 1

Quickbooks Enterprise 2024 Asking for Windows Admin Credentials

Bonjour,

je rencontre une erreur lorsque j’essaie d’utiliser QuickBooks. Un message s’affiche :

"There appears to be a problem with the database service that is managing access to the company file. QuickBooks can attempt to fix the database service. Would you like QuickBooks to fix the problem?"

Je n’ai pourtant pas encore créé de fichier d’entreprise. Pouvez-vous m’aider à résoudre ce problème ?
Merci d’avance pour votre assistance.

Cordialement

NicoleAscencionS
Moderator

Quickbooks Enterprise 2024 Asking for Windows Admin Credentials

Passons en revue quelques étapes de dépannage pour résoudre l’erreur que vous rencontrez dans QuickBooks, yebe.

 

Tout d'abord, téléchargez et installez QuickBooks Tool Hub. Cela vous aidera à corriger les erreurs courantes. Voici comment:

 

  1. Fermez votre QuickBooks.
  2. Téléchargez la version la plus récente du QuickBooks Tool Hub.
  3. Enregistrez le fichier dans un endroit où vous pourrez le retrouver facilement.
  4. Ouvrez le fichier que vous avez téléchargé.
  5. Suivez les étapes à l’écran pour installer et accepter les termes et conditions.
  6. Une fois l’installation terminée, double-cliquez sur l’icône sur votre bureau Windows pour ouvrir le hub d’outils.

 

Ensuite, utilisez les outils du centre d’outils QuickBooks pour vous aider à résoudre les problèmes de réseau. Ensuite, veuillez vérifier si votre QuickBooks est mis à jour vers la dernière version.Vérifiez également les paramètres de votre pare-feu et assurez-vous que QuickBooks est autorisé à le traverser.

 

Vous pouvez toujours revenir sur ce fil si vous avez des questions supplémentaires.

 

Avertissement : sachez que j'utilise un outil de traduction pour aider à comprendre et fournir la solution ci-dessus en français.

 

 

Let’s go through some troubleshooting steps to resolve the error you’re encountering in QuickBooks, yebe.

 

First, please download and install the QuickBooks Tool Hub. This will help fix common errors. Here’s how:

 

  1. Close your QuickBooks.
  2. Download the most recent version of the QuickBooks Tool Hub.
  3. Save the file somewhere you can easily find it.
  4. Open the file you downloaded.
  5. Follow the on-screen steps to install and agree to the terms and conditions.
  6. When the installation finishes, double-click the icon on your Windows desktop to open the tool hub.

 

Next, use the tools in the QuickBooks Tool Hub to help with Network Issues. Then, please check if your QuickBooks is updated to the latest version. Also, review your firewall settings and make sure QuickBooks has permission to go through it.

 

You can always revisit this thread if you have any additional questions.

 

Disclaimer: Please know that I'm using a translator tool to help understand and provide the solution above in French.

SIAB
Level 7

Quickbooks Enterprise 2024 Asking for Windows Admin Credentials

@yebe 

Can you open the sample file?

yebe
Level 1

Quickbooks Enterprise 2024 Asking for Windows Admin Credentials

I don't have the file I want to create and this message appears, it asks for administrator permission, and displays this error code so it is impossible to create a sample file

SIAB
Level 7

Quickbooks Enterprise 2024 Asking for Windows Admin Credentials

Which QB Desktop year version do you run?

Can you login to CAMPS and find your license code there?

https://camps.intuit.com

 

dunCAN2022
Level 1

Quickbooks Enterprise 2024 Asking for Windows Admin Credentials

I totally hope you get this message.... It's only 10 months late. I feel your pain as an IT Administrator.  We just upgraded to Windows Server 2025 - on a VM server using QB Desktop Enterprise 2024 with 1-30 users around 20 company files on Term Serv and sharing data on DC/Data Server and have been struggling with both for awhile and had on our previous server as well.  Hence we upgraded thinking hardware and resources were the issue.  New server - same issues - hosting  / sharing / crashing; running dbmanager and scanning constantly; shared drives dropping.  I called QB Enterprise support as we paid a lot of money for 1 year to have all of these issues.   I was told that this was not a supported way to run QB using the DBMgr and data on the data server  while hosting the QB app on Term server. They don't support using Term server at all... (What?? It's not Enterprise if you can't host it for lots of users inside and outside your business - Why sell it then - Hello!) I was told to move my files from the Data server to over to the Term Server with the company files located in root folder C:

 

While the crashing and hosting issues stopped, the sharing and admin permissions started. We started giving everyone, objects and services everything (db mgr, files and qb app need admin permission) - and were still getting 1 person everyday or so that needed "admin permission to run quickbooks". I almost made them all admins to make it stop. It seemed as though once you log in as admin on the TS for 1 person - everyone else's worked - until it didn't.  Sound familiar?

 

One of the notes online in this forum somewhere said to give the QB app "admin permissions" in the Properties of the QB app itself. I tried that and then everyone received the DB screen shots you provided when opening QB.  Although we are allowing QB to run as an admin, they were logging into the TS with a different user and password but they still needed to log into the app with the admin credentials. GroundHog Day - everyday.... all day (this is the part where I am rolling my eyes up into my head and contemplating a new career path)  We removed the run as admin permissions by the way.

 

I looked on the Intuit website - the  resources tab to see if I could find someone to help as I am beyond getting anywhere with how to resolve this issue and my boss is stalking me constantly about an update to this issue. I started looking for an outside QB advisor on the Intuit site to help - anyone - besides Intuit that knows anything about hosting QB Enterprise. I checked the "resources tab in the support ribbon and filtered by QB Desktop Enterprise" and found a few outside vendors to contact for support. I called one and he was extremely helpful. Like 10 mins helpful he gave me the meaning of life - or life with QB. 

 

I have not tried this yet, as I can't make one more change to QB or files or the app today without my entire office walking out, but it makes sooo much sense. I am not sure if you have already done this but he said to move the actual QB Company files on the Term Server to: "Users / Public / Documents / Intuit / QB / Company Files".  You don't even need to create the folder, it already exists! The permissions in public are not stringent so access permissions are very minimal. Eureka!  I wish someone would have shared this with me earlier.  I did not see anything in the install / migration anywhere about this. Meanwhile I have to go tell everyone in my office that their shortcuts aren't going to work and there's another modification coming soon. Yay me!  

I really hope this solves your issue if you are still fighting this. 

 

Cheers!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us