Documentation
Getting Started
Installation
Data Grid
Approvals
Administration
Account & Security
Integration & Staging
Architecture
System Requirements
Installation steps
1
Install SQL ServerRequired
Stores all master data, models, entities, and audit history
SQL Server 2016+ — requires CREATE OR ALTER, OPENJSON, and FOR JSON PATH. Skip if you already have one.
Enable TCP/IP — Primentra connects over the network, not named pipes
Start SQL Server Browser service — required to resolve named instances
Optional: Enable Full-Text Search for faster word search on large datasets
2
Create database & service accountRequired
Creates the Primentra database, a dedicated login, and permissions
Run setup-db-and-user.sql as sysadmin in SSMS
Change the default password first — the script ships with a placeholder password
3
Install PrimentraRequired
Run the installer, then open the app — a setup wizard walks you through connecting the database, deploying the schema, and creating your admin account
Run Primentra-Setup-vX.X.X.exe as Administrator
Node.js LTS installed automatically if missing or too old
★
Production deployment (IIS)Optional
Optional — HTTPS, custom domain, or port 80/443 access
IIS with URL Rewrite for SPA + ARR reverse proxy for /api
Before installing Primentra, make sure your environment meets these requirements:
- Operating system — Windows 10, Windows 11, or Windows Server 2016 or later
- SQL Server — SQL Server 2016 or later (Express, Standard, or Enterprise) — can run on the same machine or on a separate server on the network. You can use an existing SQL Server if your organisation already has one. Full-Text Search is optional — it improves search speed on large datasets but is not required
- Administrator rights — Required to run the installer and register a Windows Service
- RAM — Minimum 4 GB (8 GB recommended for datasets over 100,000 rows)
- Disk — 400 MB for application files, database storage depends on data volume
- Network — Port 3001 by default (configurable during installation)
Node.js does not need to be pre-installed. The Primentra installer includes Node.js LTS and will install or update it automatically.
SQL Server 2016+ is required because Primentra uses
CREATE OR ALTER, OPENJSON, and FOR JSON PATH — features not available in older versions. SQL Server does not need to be installed on the same machine — you can point Primentra at any reachable SQL Server instance on your network.