quickbooks work with the file on a synology NAS drive

Does anyone know of a way I can make quickbooks work with the file on a synology NAS drive
LVL 3
Abraham DeutschIT professionalAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Andrew LeniartEE Senior Editor & Independent IT ConsultantCommented:
If you map a drive letter to the folder the file resides on, then it should work fine, albeit slower. I've used that method to allow accountants to open files directly from a File Server share to do that. Quickbooks doesn't like UNC paths and will generally not work and cause issues without a mapped drive letter.
0
JohnBusiness Consultant (Owner)Commented:
If it is remote on a drive setup like this, you need to install the Server Manager. I do not think you can install the Server Manager on your NAS, so then this will not work.

To map a folder and use the file over a network drive like this is not supported and can break your company file, so do not do this.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Andrew LeniartEE Senior Editor & Independent IT ConsultantCommented:
like this is not supported and can break your company file, so do not do this.
On an unstable network connection, yes, there can be issues, but that's also true for just about anything like MYOB, Handisoft etc.. I supported the accounting firm I worked with for over 17 years and we used the mapped drive letter method from QuickBooks versions back to v7 if memory serves.

Don't recall ever breaking a QBW file to the point where it couldn't be opened. Worst that ever happened was the transaction being worked on at the time of the network interruption was lost, and perhaps a rebuild required to restore integrity. Not an ideal solution I agree, but it does work.
0
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

JohnBusiness Consultant (Owner)Commented:
QB is a very chatty database and I never recommend server access on anything but a fast LAN.  Too many issues from my Clients for using QB on slow networks remotely.
0
Abraham DeutschIT professionalAuthor Commented:
The issue I'm facing in the database manager will not recognize any mapped drives to the synology or network path need find a way to outsmart quick books to see the map as local
0
Andrew LeniartEE Senior Editor & Independent IT ConsultantCommented:
I never recommend server access on anything but a fast LAN
Yep, agreed. Though most LANS these days run at GB speeds so it shouldn't be an issue. Back with the earlier QB versions, we were using it on a 100MB LAN and though it worked fine, it was quite slow. Still, it was more reliable than trying to get the accountants I was supporting at the time to remember copying the QB file back to the server after they updated it, so I just told them they had to live with it :)
0
Abraham DeutschIT professionalAuthor Commented:
I am using quick books for years the file is on the file server and have a map on all pc no issue but with the NAS I cannot make it work
0
JohnBusiness Consultant (Owner)Commented:
The issue I'm facing in the database manager will not recognize any mapped drives

You can try using QuickBooks in MultiUser Mode on your local network with one Machine that owns the file. That keeps it off the NAS.
0
Andrew LeniartEE Senior Editor & Independent IT ConsultantCommented:
The issue I'm facing in the database manager will not recognize any mapped drives to the synology or network path
That's because it's unsupported as John said :) We never bothered with using the database manager and opened the QBW file directly.

need find a way to outsmart quick books to see the map as local
A folder redirection via GPO could work for you here. Tried that?
0
arnoldCommented:
As others pointed out, when quickbooks accesses a company file on a network device, it expects a QB database monitor to arbitrate access, creating the ..ND file...

Why not have the company file local on the system and use the backup tools to backup the company file to the synology drive?

Whether the file is on the synology drive or local, a second, third copy for backup purposes should be maintained. everything failes it is in many cases only a question of when.
0
John McNeilPrincipalCommented:
Not sure if the Synology has ISCSI functionality but you create an ISCSI drive on your computer with the Synology as the target create the local drive in disk manager and then QuickBooks will recognize the drive as if it was local.

Regards,
JMN
0
Abraham DeutschIT professionalAuthor Commented:
QuickBooks is in MultiUser Mode and is hosting the multi user access
0
JohnBusiness Consultant (Owner)Commented:
I did not mean to confuse things. What I meant was to have QuickBooks and its file on a local PC on the LAN network enabling other users to use it.
0
Abraham DeutschIT professionalAuthor Commented:
A folder redirection via GPO
why is it you think that if the share is doen via GP it should be different?
0
Abraham DeutschIT professionalAuthor Commented:
have QuickBooks and its file on a local PC
Will do so if will not be able to figure out something, but still trying
0
JohnBusiness Consultant (Owner)Commented:
I think a share by GPO is a mapped drive and your NAS wants it as local
0
Abraham DeutschIT professionalAuthor Commented:
Iren the file doctor pointed to the file on the NAS selected the option workstation and got the following results (you can ignore the anti-virus issue since I also ren it when it was disabled and then this line was not there
qbws.JPGqbfd.JPG
0
Abraham DeutschIT professionalAuthor Commented:
I already opened on the NAS drive the ports recommended by intuit
0
Abraham DeutschIT professionalAuthor Commented:
Windows firewall I disabled for now
0
Abraham DeutschIT professionalAuthor Commented:
On this computer you can see all services are running
srv.JPG
0
Abraham DeutschIT professionalAuthor Commented:
Now I ren the file doctor as the server (don't think this is the right choice but still worth a try)
qbdfd.JPG
0
JohnBusiness Consultant (Owner)Commented:
QBDDM.. comes from the Server Manager which I do not think will install as a program on your NAS
0
Abraham DeutschIT professionalAuthor Commented:
But don't you think the correct option should be workstation and there is does not complain about QBDDM
0
JohnBusiness Consultant (Owner)Commented:
I am only suggesting Workstation because you cannot properly use a NAS.  

Otherwise, do you have a Server??  Then install the QB data file on a Server, not NAS.
0
Abraham DeutschIT professionalAuthor Commented:
No its a small office and thy want to Centralize all their stuff on one place I set then up this NAS works great till I got to qb
0
JohnBusiness Consultant (Owner)Commented:
How many QB users?  Run it on a workstation on the local LAN. The workstation needs to be running all the time with QB running but it can be locked (running).
0
Abraham DeutschIT professionalAuthor Commented:
Run it on a workstation
This is how it is now, and if I will not figure out someway to make this work I will leave it as is. but trying if will be able to make it work it will make happy the client.
0
Abraham DeutschIT professionalAuthor Commented:
I tried opening qb by clicking on the file, qb started but then I got the following screen
EC.JPG
0
JohnBusiness Consultant (Owner)Commented:
When I see that error, usually (not always) QBCFMonitor Service is not running and needs to be started. The other reason is a network blocking error.
0
Abraham DeutschIT professionalAuthor Commented:
QBCFMonitor Service is not running
It's running
srv.JPG
0
Abraham DeutschIT professionalAuthor Commented:
In database server manager / browse Will not open Network or show mapped drives
sf.JPG
0
JohnBusiness Consultant (Owner)Commented:
Make sure the workstations running QuickBooks can map folders and files (NET USE Z: \\  mapping) on the other machine and that firewall is not blocking connections.
0
Abraham DeutschIT professionalAuthor Commented:
Have no issue mapping folder from other computer and on the NAS
0
JohnBusiness Consultant (Owner)Commented:
Take the NAS out of the loop.

If QuickBooks is on Workstations you probably do not need that. Uninstall the server manager and then folder sharing and multiuser mode should work.
0
John McNeilPrincipalCommented:
As I  indicated above you can create an ISCSI host and target if it's a newer Synology to the workstation that will host the QB application.  You then share the QB drive from that local workstation and QB will allow you to go into multiuser mode.  1 caveat is you must leave that client workstation on all the time as your QB machine.  In most  of my client environments I just create a vm workstation and load the QB application there create the ISCSI on Synology and on the VM machine.  QB is happy and you can serve up the QB database from a NAS drive.  I have done this many times with WD NAS units but I am sure Synology work the same as long as it has ISCSI feature.
0
Andrew LeniartEE Senior Editor & Independent IT ConsultantCommented:
If you create a Junction Link to the folder on the NAS drive, QuickBooks should see it as a local folder and behave accordingly.

You can use Junction v1.07 to create the link, or just use DOS and Powershell commands to achieve the same thing.

This discussion on Stack Exchange provides some excellent examples.

Hope that's helpful.

Regards, Andrew
0
John McNeilPrincipalCommented:
Sorry not saying one way or the other is specifically better just that what your asking is possible if it is setup as I have indicated.
0
Abraham DeutschIT professionalAuthor Commented:
ISCSI
The problem with iscsi is that it still uses the actual pc resources to connect to the qb file, plus the backup will be split between the nas and the actual pc
0
John McNeilPrincipalCommented:
QB will backup the files in the exact same way as it sees the data as located on a locally mounted drive.  I have not been able to perform this task without a wkstn to run additional services because of exactly what John Hurst said above regarding QBDDM.  That's why I generally put this on a separate VM workstation but I know that's not always possible in all situations.  Benefit of ISCSI is it will allow client side caching which will improve your QB systems database write and read cache dramatically over using  SMB.
0
Abraham DeutschIT professionalAuthor Commented:
Officially this will not work
https://forum.synology.com/enu/viewtopic.php?t=48954
https://community.intuit.com/questions/1439304-quickbooks-2016-on-nas

I am close to give up on this one I will have a look on  Junction although I think it only works to local files not to network shares, but will try.

Will also look in ISCSI
0
JohnBusiness Consultant (Owner)Commented:
Officially this will not work

That is pretty much where I began earlier.
0
Abraham DeutschIT professionalAuthor Commented:
That is pretty much where I began earlier
agree, but I thought I may find a some kind of workaround
0
arnoldCommented:
For a multi-user, the only workaround is the iscsi solution suggested which will be making one PC as the host of the share and qb db manager Dan monitor and arbitrate access.

Have looked into a Linux/UNIX based file share cifs host on which qb Linux db monitor might be used, but have not located such ....
0
Abraham DeutschIT professionalAuthor Commented:
At the end I was not able to find a simple workaround, qb wants is data manager on the machine the file is since a LAN is linux it will not host data manager, with iscsi it may work but was not willing to invest more time for this client. I had the same issue with a sql program he has. would I know before that he wants it for more then regular file hosting I would look in to the 218+ which is  able to run its own virtual pc (I got him the 218 the + is like $50 more).
Thank you all for help me trying but had no luck on this one
0
JohnBusiness Consultant (Owner)Commented:
Thanks for the update and I was happy to work with you
0
dkhwkj qdoiCommented:
So after talking to intuit  they gave me this solutions the works
Multi User Support

Follow the "Enable Alternate Setup Mode" in the bottom.

You will need to create a different users in QB for each person that will open the file
You can do that in QB under Company >> Set up users and password

Good luck
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Networking Hardware-Other

From novice to tech pro — start learning today.