Starting in R11.2 we started using an import user for several processes in MarketingPilot including Email Marketing and many of the import processes. The import user is a SQL Server user, the user needs to be mapped to the MarketingPilot database and have the mp_user and mp_import database roles. Once the user is setup in SQL, it needs to be added to your MarketingPilot application on the Site page, the field is towards the bottom of the page. Once you add the import user and the password (don’t forget to enter it twice), hit save, if you don’t get an error, you are good to go, if you get an error, keep reading for some tips to fix the issue.
If you receive an error stating the import user is not setup correctly there are a few items to check:
1. Be sure the import user is mapped to your MarketingPilot database
2. Be sure the user has the mp_user and mp_import roles
3. Check the exceptionlog in the Web Server folder, if you receive an error similar to ” Cannot execute as the database principal because the principal “dbo” does not exist, this type of principal cannot be impersonated, or you do not have permission.” You may have an issue with your database owner. This error normally appears when you have upgraded your SQL server from 2005 to 2008. To correct this issue you can make the SA user the database owner by running this sql on your MarketingPilot database: EXEC sp_changedbowner ‘sa’
This will change the database owner and the error should go away.