Skip to main content
Level 2
April 16, 2022
Solved

Need clarification on why NAS can't be used to host Lacerte file share

  • April 16, 2022
  • 2 replies
  • 35 views

Hi all. I'm getting caught up to speed on Lacerte. I'm exploring various options for a client who's been plagued with issues and after testing the folder share using a high end Synology NAS it appears to have resolved just about everything. I'm confused as to why it "can't" be used. Is it simply a matter of Lacerte support not being able to assist if you have an issue while using it? I've done extensive testing and it seems to work just fine with he program. I'm confused about the posts I found while searching which suggest it doesn't work when others have tried it. Thank you.

This topic has been closed for replies.
Best answer by sjrcpa

I think it can be used but Lacerte won't support it.

2 replies

qbteachmt
Level 15
April 16, 2022

I recommend googling:

lacerte nas network

And read the topics from this forum that are in the results.

Don't yell at us; we're volunteers
techguy99Author
Level 2
April 16, 2022

Hi @qbteachmt. That's actually what I did and what led me here. There is no technical explanation I have come across that makes sense so I need clarification.

sjrcpa
sjrcpaAnswer
Level 15
April 16, 2022

I think it can be used but Lacerte won't support it.

The more I know the more I don’t know.
qbteachmt
Level 15
April 17, 2022

As I pointed out in my initial attempt to help you get your information, there are lots of resources on the web for the issue, if you want to "get technical" that don't need to be copied into a Tax Preparer End User community forum. I didn't realize it might be difficult to do the search for yourself, so I will offer some links and highlights here and you can pursue the links to read technical details and perhaps see other links:

https://flylib.com/books/en/3.174.1.26/1/

"The caveats for NAS are twofold. The architecture employed by NAS products does not lend itself to applications that are dependent on sophisticated manipulation of the storage media meaning any application that either has its own embedded file system to map and store data to the online storage directly, or that works with data management products, such as relational databases, which do the same. Secondly, applications that deal with highly volatile data do not perform well in other words, data that is subject to constant and continuous updating by a large user base."

Having a management utility can be helpful: https://www.cleartechnologies.net/network-attached-storage-nas-is-better-with-vsi/

"Network Attached Storage (NAS) is an exceptional solution for customers who wish to quickly and extensively share files within their network. The reasonable cost of NAS devices has led to expanding usage by organizations, and has led to the development of clustered NAS solutions by IBM and other storage hardware suppliers.

Regardless of the storage technology used, the need for storage continues to expand exponentially. Storage demand is primarily driven by unstructured data, which is defined as data that is not part of a relational database. NAS solutions are specifically designed for storing this type of unstructured data."

This document compares NAS and SAN; https://www.snia.org/sites/default/education/tutorials/2008/fall/applications/StephenDaniel_Running_Database_Application_NAS.pdf

And: https://community.spiceworks.com/topic/458814-for-a-sql-db-which-would-be-best-san-or-nas

To help understand that other solutions are available, and the history of NAS including the issue of corrupt DB. Another proposal as a make-it-work:

https://www.brentozar.com/archive/2012/01/sql-server-databases-on-network-shares-nas/

And interestingly enough, the gorilla in the room has this reference material: https://docs.microsoft.com/en-us/troubleshoot/sql/admin/support-network-database-files

Including: "Additional notes

Incorrect use of database software with a NAS product, or database use with an improperly configured NAS product, may result in data loss including total database loss. If the NAS device or network software does not completely honor data guarantees, such as write ordering or write-through, then hardware, software, or even power failures could seriously compromise data integrity."

I found a nice Q&A that helps with writes, torn pages, etc: https://dba.stackexchange.com/questions/78892/can-you-put-a-sql-db-on-a-nas

How heartbreaking is this: "The entire DB got corrupted, many files had a size of zero"

Now, obviously, if you are the programmer of Lacerte, you have more control for making it fault tolerant for NAS purposes or at the least, packeting the data in processible chunks. I am part of the Intuit Developers' Group and there is specifically a Lacerte SDK you can use, if you want to write an integration intermediary that provides gatekeeping to the NAS.

Group: https://proconnect.intuit.com/community/lacerte-sdk-group/gp-p/501 (a subset of this forum platform)

and the SDK resources:

https://developer.intuit.com/app/developer/lacerte-sdk/docs/lacerte-get-started

Hope that helps.

 

 

Don't yell at us; we're volunteers
techguy99Author
Level 2
April 17, 2022

That does help. Thank you @qbteachmt.