Documentation
Getting Started
Data Grid
Modeling
Business Rules
Approvals
Users, Roles & Security
Administration
Integration & API
Migrating from MDS
Architecture
Documentation/Installation/Create Database & Service Account

Create Database & Service Account

Create the database and the service account before you install Primentra. The installer needs a database to connect to during first-run setup.

What this step does

The script setup-db-and-user.sql creates an empty database, a dedicated login, and the permissions Primentra needs. The application never connects as sa. It uses a restricted account that can reach only its own database.

Run the script

  1. Open SQL Server Management Studio and connect as a sysadmin user, for example sa.
  2. Open setup-db-and-user.sql. Download it from primentra.com, or find it in the scripts folder of the installation directory after you install Primentra.
  3. Replace the placeholder CHANGE_THIS_PASSWORD in the CREATE LOGIN statement with a strong password.
  4. Execute the script.
  5. Write down the database name, the user name, and the password. The setup wizard asks for all three.
Never run the script with the placeholder password. It ships as a placeholder, not as a usable secret.

What gets created

ObjectNamePurpose
DatabasePrimentraEmpty at this point. Tables are created later during Setup Database
Loginprimentra_svcSQL Server authentication. The application's service account
Roleprimentra_appHolds every grant. primentra_svc is a member

Permissions granted to `primentra_app`

  • SELECT, INSERT, UPDATE, DELETE and EXECUTE on the dbo and mdm schemas — data access and stored procedures.
  • REFERENCES on both schemas — foreign keys during schema setup.
  • CREATE TABLE, CREATE PROCEDURE, CREATE VIEW, CREATE FUNCTION, CREATE SCHEMA — schema deployment and staging tables.
  • ALTER on both schemas — migrations and integration views.
  • Membership of db_ddladmin — Full-Text Search catalog and index creation.

SQL Server Agent access

The script also adds primentra_svc to the SQLAgentUserRole role in msdb. That is the least privilege that lets setup create the Primentra_Scheduler job, which runs staging batches and applies your retention settings.

Without this grant the schema still deploys, but the job is not created and you have to add it by hand. See Install Primentra.

Ready to get started?

Start managing your master data with Primentra today.

View Pricing
Create Database & Service Account | Installation | Docs | Primentra