Requirements

1. Service account requirements

• • Account type: Local or domain service account
  • Interactive login: Not required per your organization’s policy
  • SQL access: Do not use the service account for database access. Instead, configure the application to use a dedicated SQL login.
  • Permissions needed:
    • Local permissions to run the application services
    • If using a domain account, grant “Log on as a service” via Group Policy
  • How to assign "Log on as a service":

1. 1. 1. 1. Log in to the server with administrative rights.
         2. Press Win + R on your keyboard, type secpol.msc, and press Enter.
         3. Go to:
            Security Settings > Local Policies > User Rights Assignment.
         4. Double-click Log on as a service.
         5. Click Add User or Group.
         6. Enter the service account name (e.g., DOMAIN\ServiceAccount) and click OK.
         7. Click Apply and OK.
2. Database requirements

• • Supported SQL Server versions: Refer to Flexera documentation.
  • SQL login account:
    • Must be created on the SQL Server with db_owner rights to the application's database.
    • Use SQL Authentication (Windows Authentication is not supported in this scenario)

Installation instructions

1. Install the Data Platform and User Console as usual using the installation wizards.
2. During the Configuration Wizard step:
   1. Choose SQL Authentication.
   2. Enter the SQL login credentials you created.
   3. Complete the configuration process.

Optional: Modify the configuration file for SQL auth on an existing Data Platform server

Follow these additional steps if you're reusing an existing SQL database that was initially configured with Windows Authentication.

1. Create a SQL Login and User

Create a SQL login and associate it with the BDNA and BDNA_PUBLISH databases. Make sure that the login’s default schema is dbo and that it is a member of the dbo_role for both the BDNA and BDNA_PUBLISH databases.

SQL Statement:

USE [BDNA_PUBLISH];

GO

-- Example: Creating a SQL user named FlexeraDBO

CREATE USER [FlexeraDBO] FOR LOGIN [FlexeraDBO] WITH 

DEFAULT_SCHEMA = [dbo];

GO

EXEC sp_addrolemember 'db_owner', 'FlexeraDBO';

Repeat the same steps for the BDNA database as well.

2. Modify the configuration file

By default, Data Platform expects two separate SQL users. Since you're using only one, you need to update the configuration file manually.

Steps:

1. 1. Open a text editor, such as Microsoft Notepad, as an Administrator.
   2. Navigate to:
      Data Platform\conf\Norm.Configuration.config
   3. Edit the following sections:

NDB Section:

• • • Set the user and password to your SQL login credentials.

PDB Section:

• • • Set the user to BDNA_Publish.
    • Ensure the PDB_DBConnection and NDB passwords are the same.
    • Change the User to your SQL login.

3. Re-run the Configuration Wizard

1. Launch the Data Platform Configuration Wizard.
2. When prompted for Database Server Information, switch to SQL Authentication.
3. Enter the SQL login credentials you configured earlier.