5. Prepare SQL Server Access

Overview

PI Nexus+ stores all application configuration and inventory results in SQL Server. Before installation, decide which SQL Server instance will host the PI Nexus+ database and which Windows account will perform the database setup step.

Recommended database name:

PINexus

The database setup step runs after the installer finishes. It prepares the SQL database and grants access to the PI Nexus+ service account. The account running that setup step must have enough SQL Server permissions to create or update the PI Nexus+ database.

Use a SQL setup account that can:

• Connect to SQL Server.
• Create a database.
• Create a Windows SQL login.
• Create a database user.
• Grant database permissions.

In most installations, the SQL setup account is the Windows account of the administrator performing the installation. The PI Nexus+ service account is the account that will run the application after setup. Keep those roles separate unless there is a deliberate reason to use the same account for both.

A good result for this section is that you know the SQL Server name, the database name, and the Windows account that will run the database setup window after the installer finishes.