SQL Server¶
lexbizz ERP Application uses SQL Server Database. In order to start the application on a local machine, user need to install an English Version of the SQL Server. The tool offers installation of SQL Server 2017 Express Edition. In case there is a another version installed on the machine, then the tool will show the version and the edition in the Verification process. lexbizz/Acumatica application do work with higher versions of the SQL Server.
Installation¶
Using the tool
You can install the SQL Server 2017 Express edition using the tool like any other package. See How to Install a Package? for more information.
Manual
Using choco package manager.
1choco install sql-server-express --version 2017.20190916 --params "/ENU:True /SQLCOLLATION:SQL_Latin1_General_CP1_CI_AS" -y
OR
Using Microsoft Website SQL Express 2017
Manage User Permissions¶
The SQL Server, installed using the tool, do not implicitly grant access to the Windows Users. The Server is installed under LocalSystem account. In order to grant access to the local logged in user, please use the Adjust User Permissions option. This option will create a login for a logged in Windows User.
Manage System Account Permissions¶
If you have manually installed the SQL Server then you need grant access to the LocalSystem account. Earlier this was a manual step howver now you can use the following option to grant access to the system account. In case of missing access rights, the tool will not be able to create a application database.
Restart SQL Service¶
This option restarts the local SQL Service.
SQL Server ODBC Driver¶
This component is required by the tool to provision application database. You can install this component using the normal package installation mechanism. See How to Install a Package? for more information.
Manual Installation
Install SQL Server ODBC Driver (required by lexbizz DevOps tool)
1choco install sqlserver-odbcdriver