Dear All,
I need your help. How we can install SENAITE Open LIMS in Windows Server environment. Can we use MS SQL Server as database?
Thank you for help in advance.
Kind Regards,
Vijay
Hello,
AFAIK you can run Plone/Senaite on Windows Systems, but thats not recommended.
Database backend is ZOPE, this cannot be simply changed.
Hi @vijayb.kumar, to run Senaite in a Windows Server I would suggest installing Senaite in a Virtual Machine with Debian or Ubuntu. You can use Virtual Box and the Ansible recipe I will list below to achieve this (https://www.virtualbox.org/). Another option is to install Senaite through a Docker container.
- Installation manual for Senaite in Ubuntu: https://www.senaite.com/docs/installation
- Senaite Docker: https://github.com/senaite/senaite.docker
- You can also have a look at the Ansible recipe: https://github.com/senaite/senaite.ansible-playbook#senaite-ansible-playbook
Regardin MS SQL database, in theory you could, but note that Senaite is build on top of Plone 4 (https://plone.com/), therefore the database that uses is ZODB. There are tools to use Plone together with relational databases (https://github.com/zodb/relstorage) but in my opinion they add another layer of complexity and point of failure.
Regards,