Must we install the QuickBooks Database Server Manager on the server if we do not have multiple users accessing the same Quickbooks file.
I work for a small accounting company and they received lots of Quick Book files from their clients. The staff uploads the file to the server's shared drive and process the work using their desktop where Quicbooks is installed. There is never more then one person in the quickbooks file at a time.
We are considering moving to AWS and I wanted to know if I can just create an S3 bucket to store all the data, map the S3 to their desktop and have them work just like a file server in the office.
To support the QB Database server Manager I would need to create an EC2, Install QuickBooks Database Server Manager on it, attached the S3 to the EC2 and have the server manager scan for Quickbooks files.
Your feedback is appreciated.
Solved! Go to Solution.
I appreciate the thorough background you've provided, Jeffrey. Your focus on enhancing efficiency within your accounting firm stands out, and I'm here to support you in making informed decisions for your setup.
To begin, I want to confirm that your understanding of the QuickBooks Database Server Manager setup is accurate. Since your staff works with files individually and there are no multiple users accessing the same file simultaneously, there is no need to install the QuickBooks Database Server Manager.
Furthermore, you are correct that if you plan to support the QuickBooks Database Server Manager, creating an EC2 instance, installing the QuickBooks Database Server Manager on it, attaching the S3 bucket to the EC2, and having the server manager scan for QuickBooks files is an excellent approach.
Regarding your plan to utilize an S3 bucket for storing QuickBooks files on AWS, while S3 can serve as a storage solution, QuickBooks Desktop requires direct access to company files on a local drive or network share. Mapping an S3 bucket as a drive will not provide the necessary functionality, as QuickBooks expects files to be located on a local file system rather than in cloud storage.
However, you can use third-party applications to map an S3 bucket to your desktop, allowing access as if it were a local drive. This would enable file uploads and downloads directly from your desktop.
I recommend visiting the QuickBooks App Store and navigating to the CATEGORIES section to explore tailored solutions that meet your needs for managing QuickBooks files.
I've included a screenshot for reference:
Additionally, I'd like to share some valuable resources for tips on troubleshooting QuickBooks performance and providing insights on managing data files effectively for optimal performance:
Thank you for your insights and for sharing your plans regarding the QuickBooks Database Server Manager. Your input demonstrates your commitment to optimizing your accounting processes. If you have any more questions or need further assistance as you move forward, revisit us in this channel. The QuickBooks Community team is always here for you.
I appreciate the thorough background you've provided, Jeffrey. Your focus on enhancing efficiency within your accounting firm stands out, and I'm here to support you in making informed decisions for your setup.
To begin, I want to confirm that your understanding of the QuickBooks Database Server Manager setup is accurate. Since your staff works with files individually and there are no multiple users accessing the same file simultaneously, there is no need to install the QuickBooks Database Server Manager.
Furthermore, you are correct that if you plan to support the QuickBooks Database Server Manager, creating an EC2 instance, installing the QuickBooks Database Server Manager on it, attaching the S3 bucket to the EC2, and having the server manager scan for QuickBooks files is an excellent approach.
Regarding your plan to utilize an S3 bucket for storing QuickBooks files on AWS, while S3 can serve as a storage solution, QuickBooks Desktop requires direct access to company files on a local drive or network share. Mapping an S3 bucket as a drive will not provide the necessary functionality, as QuickBooks expects files to be located on a local file system rather than in cloud storage.
However, you can use third-party applications to map an S3 bucket to your desktop, allowing access as if it were a local drive. This would enable file uploads and downloads directly from your desktop.
I recommend visiting the QuickBooks App Store and navigating to the CATEGORIES section to explore tailored solutions that meet your needs for managing QuickBooks files.
I've included a screenshot for reference:
Additionally, I'd like to share some valuable resources for tips on troubleshooting QuickBooks performance and providing insights on managing data files effectively for optimal performance:
Thank you for your insights and for sharing your plans regarding the QuickBooks Database Server Manager. Your input demonstrates your commitment to optimizing your accounting processes. If you have any more questions or need further assistance as you move forward, revisit us in this channel. The QuickBooks Community team is always here for you.
You need Amazon Workspace.
Thank you very much for the feedback. Your help is appreciated.
You're very welcome, @jeffreyayoub!
I'm glad to hear that my colleague was able to provide you with details about QuickBooks Database Server Manager. Your feedback is greatly appreciated, and rest assured that we're always here to help if you encounter any challenges while using QuickBooks.
We always strive to provide the best solution for your concerns when clarifying anything about QB Server Manager or if you have other questions with QuickBooks.
Simplify payday and set payroll to run automatically in QuickBooks.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here
These cookies are strictly necessary to provide you with the services and features available through our site. Because these cookies are strictly necessary to deliver the site, you cannot refuse them without impacting how the site functions.
These cookies are used to make advertising messages more relevant to you and your interests. They also perform functions like preventing the same ad from continuously reappearing, ensuring that ads are properly displayed, and in some cases selecting advertisements that are based on your interests.