Skip to main content

SQL Server Authentication

During installation, Nectari requires an administrator login on the SQL Server for database deployment.

While the built-in sa account provides full permissions, it is strongly recommended to create and use a dedicated SQL Server login for Nectari. This approach increases security and avoids relying on the sa user for routine access.

Create a dedicated SQL Server login​

You can use a custom Nectari login for secure access:

  1. Assign the sysadmin role to your Nectari Login for the installation process.
  2. After installation completes, you may remove the sysadmin role.
    The Nectari login will retain dbo (database owner) rights for Nectari databases and will have db_owner by default.
  3. If the Login was created after running the installer, ensure you set up the correct database mapping and permissions in SQL Server Management Studio (SSMS).
  4. For maximum compatibility, leave the db_owner role checked. For a more restrictive, minimum set, select only:
    • db_datareader
    • db_datawriter
    • db_ddladmin

Enable Windows Authentication​

Windows Authentication provides secure, credential-free access with native integration to your Windows environment. This avoids password exposure and leverages Windows account security.

note

The same database permissions apply whether you use SQL Authentication or Windows Authentication.

  1. Open SQL Server Management Studio (SSMS).
  2. Connect to your SQL Server instance with an admin account.
  3. In Object Explorer, expand the Security node.
  4. Right-click Logins and select New Login.
  5. In the Login window:
    • Select Windows authentication.
    • Click Search and find the Windows user, such as YourMachineName\NecBIAccount.
    • Click Ok.
  6. Under Logins, double-click the server name for your new user.
  7. In the left pane, go to Server Roles and select sysadmin for installation, or map only the needed database roles after install.
  8. In User Mapping, select the databases and assign appropriate roles (same minimum or maximum set as for SQL authentication).
  9. Click Ok to save.