Login failed for user 'YOURDOMAIN\youraccount'. in SetDEChecksTable

Owned by
Chris Hayes
Last updated: Nov 04, 2021
2 min read

You receive this error when clicking ‘Ok’ on the Data Extractor Configuration window.

The error has occurred as the Windows user you are currently logged in as does not exist in the SQL instance you are connecting to. To fix, please follow the steps below. N.B. you will need SQL Server Management Studio (SSMS) installed to do this.

  1. Log into SSMS using the SA account or another user with admin rights.

  2. Expand the Security table > right click on the Logins table > select New Login.

  3. On the Login page click Search > Locations > change to Entire Directory and click OK.

  4. Type the username that was displayed in the error (you can leave out the domain part) > click Check Names > once found click OK.

  5. Now go to User Mapping > select the Contact Group database (tick it) > select db_owner under ‘Database role membership…’ > click OK.

  6. Go back to the Data Extractor Configuration window and click 'Ok' on the error and any other messages that popup. If this has worked then everything should disappear and the services Data Extractor and Data Extractor Monitor should now be running.

Â