SQL Server Authentication

The installation packages require an Administrator Login to the Database Server.

The sa user is an administrator that can be used during the install and as the SQL Server user for SEI.

If you want to avoid using the sa user to connect to the databases, you can create an SQL Server Login for SEI:

  1. In the Server Roles list, this Login must have the sysadmin role during the install.
  1. After the install, the sysadmin role can be removed.
    Note

    As the installation ran with the custom SEI login, the dbo user will be assigned to the defined login and be given the db_owner rights.

  1. Giving full access to the Login used on the database.
    Note

    If the Login is created after the installation packages ran, the Database Mapping must also be set on the Login to grant permissions.

  2. For maximum permission, leave db_owner only. For minimum permission, tick only the following checkboxes: db_datareader, db_datawriter, db_ddladmin.

Windows Authentication for SQL

Windows Authentication for SQL provides a secure method for authentication, leveraging Windows security features while allowing users to access databases without entering their credentials (limiting the risk of password exposure).

Note

The same permissions assigned for the credentials-based SQL Server authentication are assigned for the Windows Authentication for SQL.

To enable Windows Authentication for SQL:

  1. Open SQL Server Management Studio.

  2. Connect to your SQL Server instance using your usual admin account.

  3. In the Object Explorer, expand the Security node.

  4. Right-click on the Logins node and select New Login

  5. In the Login window:

    1. Select Windows authentication.

    2. Select Search... to find and select the Windows user YourMachineName\NecBIAccount.

    3. Click OK.

  6. Expand the Security node and then the Logins node (if they are not already expanded).

  7. Double-click the server name under the Logins node.

  8. From the left-hand pane, select Server Roles.

    1. From the Server Roles list, check the box next to sysadmin.

  9. In the User Mapping section in the left pane, you can select which databases you want to grant the user access to.

  10. Once permissions are granted, click OK.