Jump to content
NWComputerGuy

Quickbooks Database Server Manager

12 posts in this topic Last Reply

Recommended Posts

So I am looking for a little guidance, and I'm pretty sure from everything I've read and watched that Docker might be my friend in this endeavor! 

I recently had my home office server crash, thankfully I had everything backed up and current and so data loss was not an issue.  The problem was a failure of windows, it was the last straw so I started hunting for an alternative, I found unRAID and was very impressed, it filled every need and seems to be much more stable for my environment!  The only thing it lacked was out of box support for my Quickbooks.

Quickbooks used to be able to use a file saved on a NAS or File Server with no problem, however new additions required the Quickbooks Database Server Manager program to manage multi users and storage.  This is why I had been using Windows.  However after a little bit of research I found that they had a Linux release of the manager in RPM (Fedora/RedHat) 

My Question is two fold, one: Do I need to install a full VM of Fedora to run this program or Two: Can I run just the program it'self in a Docker?

 

This is a link to the documentation I have checked out fro Quickbooks!

 

https://community.intuit.com/articles/1552445-install-linux-database-server-manager

Share this post


Link to post
2 hours ago, NWComputerGuy said:

My Question is two fold, one: Do I need to install a full VM of Fedora to run this program or Two: Can I run just the program it'self in a Docker?

Looking at the docs, here's how I would approach it.

1. Set up a full VM, follow the intuit directions explicitly, ensure that things actually work. I've been dealing with quickbooks for around 20 years, and past experience with the company informs me that your chances of everything "just working" is pretty much none. I would anticipate having to find workarounds and poorly documented procedures to get things working, even when you are following exactly what they say.

2. Assuming you get a working environment in a full VM, proceed to transfer that knowledge to a docker, and see if you can duplicate your VM success.

 

Can you tell I'm bitter? I've spent HOURS, many not billable, deciphering why various versions of quickbooks over the years have failed to perform or even function when installed as prescribed by their docs on plain vanilla windows server networks. Their latest offering failed to start the database manager unless you disabled some of the default services of a windows server 2016 domain controller.

Share this post


Link to post

I laughed when I read your last paragraph,  I completely understand your feelings of frustration with this company!

Thanks for your advice, I'll give it a shot in the VM and share the results.

I hope my little adventure with this issue can assist others in the same boat or maybe inspire a programmer to take matters into their own hands!!

Thanks -Scott  

Share this post


Link to post

I'd be happy to provide an update!

So after playing around with red head for a while and signing let it did not work as I expected it to with QuickBooks database manager I tried a new branch called fedora hoping that the structure would be a little bit more solid for what I was trying to do. Unfortunately I ended up with the same result, and the QuickBooks database manager did not work. So unfortunately I had to Resort back to Windows so I created a docker image of Windows 7 and installed Quickbooks on there in the default way and chose the store my file on this computer option, in essence using it as a server.

It's been a couple months now since I set up the system and it has been damn near Bulletproof, I still have access to my files with no problem and I get the benefit of having it backed up on an unraid server so I get the bonus of that environment.

Plus it doesn't hurt that Windows 7 computer networking is vastly easier then getting Linux computers to freely share with Windows PCS don't know why but I always have problems with networking Linux and windows together just seems to be my kryptonite. LOL

Share this post


Link to post
On 11/2/2018 at 8:21 AM, NWComputerGuy said:

so I created a docker image of Windows 7 and installed Quickbooks on there in the default way and chose the store my file on this computer option, in essence using it as a server.

 

Hey NWComputerGuy,

 

I am looking to do the same thing you did with Quickbooks. How do you create a docker image of Windows 7. I can only find info on how to create windows as a VM.

 

Thanks!

Share this post


Link to post

I was reading through this thread thinking it was 10 years old..but it’s rather new! I feel the pain all around but have a glimmer of hope; I’ve been running the QB Enterprise Server on Linux for years now for multi-users and it rather “stable”. 

 

Now it was a pain in the ass, docu,entatikn is next to nothing, and the last 10 years Intuit’s support (including enterprise support) does not cover how to actually install and manage their software. I went as far as contacting them asking for support on version 2014 only to be told they didn’t have a Linux install... Christ their documentation doesn’t even change between versions, they just update the date and version number.

 

Ok, enough complaining, on to the important bits. I’m about to roll out QB Enterpise 2019 on a Linux box and wouldn’t mind writing my own documents on it for others to use. My end goal is to containerize it and try to automate it from version to version, along with management controls for sys-admins.

 

Any interest?

 

 

Share this post


Link to post
10 hours ago, ForgottenPoundSymbol said:

Any interest?

Definitely. If you can document the process needed to get the database manager usable in a docker image that runs on any linux, but unraid specifically, that would be great.

Share this post


Link to post

I too would be very happy to see your process!  I really do like the stability of Linux and would be very happy to give it another try, and hearing that you have done it in the past successfully really fills me with a sense of hope on this!  Thanks for sharing your knowledge! 

Share this post


Link to post
On 11/16/2018 at 1:03 PM, jh1987 said:

Hey NWComputerGuy,

 

I am looking to do the same thing you did with Quickbooks. How do you create a docker image of Windows 7. I can only find info on how to create windows as a VM.

 

Thanks!

Sorry I didn't explain that better (At the time, I was still very new at UnRAID terminology) I did indeed use a VM with a Standard install of Windows 7 Home Prem. and not a Docker container!   Hope you were able to still setup your Quickbooks!

Share this post


Link to post
On 1/9/2019 at 7:05 PM, NWComputerGuy said:

Sorry I didn't explain that better (At the time, I was still very new at UnRAID terminology) I did indeed use a VM with a Standard install of Windows 7 Home Prem. and not a Docker container!   Hope you were able to still setup your Quickbooks!

No problem I figured out that is probably what you meant. I can't seem to get good performance from my VM. What are your hardware specs like? Do you experience any slowdowns? It seems like my VM is really sluggish.

 

Also, do you just host your files on the VM and then access them on another computer or do you log in to your VM whenever you use Quickbooks?

 

Thanks!

Share this post


Link to post

When I originally set up my VM I only did it with one core but I switched it over to 2 cores with 4 gigs of memory.  I found that I needed a little extra memory for the multiple users.  I also set it up so that way it's only role was to host the file with the database server running on VM. All of the other computers are set up with the primary software and then I map the drive to the VM. I get pretty good performance and of course QuickBooks is notoriously slow to begin with so it really doesn't matter how much processor you shove behind it!

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.