cancel
Showing results for 
Search instead for 
Did you mean: 
jeffreyayoub
Level 1

QuickBooks Database Server Manager

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
Best answer 3 weeks ago

Best Answers
Aldren18
QuickBooks Team

QuickBooks Database Server Manager

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:

 

image_720.png

 

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.

View solution in original post

4 Comments 4
Aldren18
QuickBooks Team

QuickBooks Database Server Manager

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:

 

image_720.png

 

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.

Chrea
Level 6

QuickBooks Database Server Manager

@jeffreyayoub 

You need Amazon Workspace.

jeffreyayoub
Level 1

QuickBooks Database Server Manager

Thank you very much for the feedback.  Your help is appreciated. 

GenmarieM
QuickBooks Team

QuickBooks Database Server Manager

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.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need a payroll process that works for you?

A business owner is notified that Auto Payroll is on schedule for her team.

Simplify payday and set payroll to run automatically in QuickBooks.

Explore QuickBooks Payroll

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up