Nectari ADMIN User Maintenance

After entering the wrong password five times for any Nectari user, the account is locked out.

If this account is the ADMIN account, use the Nectari Web Server with another account already setup with the Security privilege authorization level to remove the lock flag via the Administration > Security, select the Users tab.

Select the ADMIN user, and click on Unlock .

Otherwise you will need to use SQL to unlock it as specified below:

  • Start Microsoft SQL Server Management Studio.
  • Connect to your SQL.
  • Find the Nectaridatabase (normally called Nectari).
  • Start a New Query.
  • Copy the script below and execute it.
SELECT USERNAME, IS_LOCKED_OUT, FAILED_PASSWORD_ATTEMPT_COUNT
FROM [Nectari].[dbo].[SEC_USERS]
WHERE USERNAME= 'ADMIN'

If IS_LOCKED_OUT or FAILED_PASSWORD_ATTEMPT_COUNT are NOT set to 0 (Zero), then start a New Query, and execute this update statement:

UPDATE [Nectari].[dbo].[SEC_USERS]
SET IS_LOCKED_OUT = 0,
FAILED_PASSWORD_ATTEMPT_COUNT = 0
FROM [Nectari].[dbo].[SEC_USERS]
WHERE USERNAME = 'ADMIN'
  • Go back to Nectari.
  • You will be able to log back in with the ADMIN user using the current password.
  • If you do not remember the password, look for instructions on the next section.

Resetting the Nectari ADMIN Password

You can use the Forgot password? link on the NectariLogin window to reset the password.

For this to work properly, it is recommended to set a valid email address for the ADMIN account via SQL (see example below).

Verifying the ADMIN User Email

  1. Start Microsoft SQL Server Management Studio.
  2. Connect to your SQL.
  3. Find the Nectari database (normally called Nectari).
  4. Start a New Query.
  5. Copy the script below and execute it.
SELECT EMAIL FROM [Nectari].[dbo].[SEC_USERS] WHERE USERNAME = 'ADMIN'

Important
  1. This email must be a valid email that the company SMTP Serverwill allow to relay. Most companies only allow the SMTP Server to relay emails from users defined within their own domain.
  2. The SMTP address configured in the Central Point must be set with the proper address of the customer’s SMTP server. If you need to verify or do an update, you can use the Web Central Point Configurator. Otherwise, you can look for the tag <smtp server="...." /> in nec- centralpoint.xml file, located in the root directory of your Central Point.

Updating the ADMIN User Email via SQL

If you need to change the ADMIN email, you can use an SQL Statement similar to this one below, replacing ValidEmail@yourcompany.com with a valid email for your company:

UPDATE [Nectari].[dbo].[SEC_USERS]
SET EMAIL = 'ValidEmail@yourcompany.com'
WHERE USERNAME = 'ADMIN'