Database install results in EventID: 18456 (Failure Audit) in the application log (4264505)

When attempting to load the tables in the SQL Server Configuration area, the following event may be generated in the Application Log:

EventID: 18456
Type: Failure Audit
Description:

Login failed for user 'DOMAIN\ADMINUSER.' [CLIENT: <local machine>]

This issue may be caused because the credentials specified do not have the correct privileges to access the nme40db database.

To resolve the issue, perform the following:

1. Use SQL Management Studio to create a new login for an admin equivalent user.
2. Use Windows Authentication for that particular login.
3. In the status section, make sure that the login is "Enabled".
4. Ensure that this new login is given the correct rights on the nme40db database. This can be done in the "Server Roles" section, by checking on all the roles for the database.
5. Log into windows on the Notes Migrator for Exchange (NME) machine with that particular user and then configure NME to use Windows Authentication in the SQL Server configuration.
6. Alternatively, SQL authentication can be used specifying the appropriate credentials.

By following the above, this should enable connection to the database successfully without generating the failure audit event.