Username returned by the Secure Store Provider is not of the form ‘Domain\User’

In this article we will be seeing how to resolve the following error The username returned by the Secure Store Provider is not of the form 'Domain\User'.

Error:

I have created an external content type using SharePoint Designer which is connected to SQL database using Secure Store Application ID as shown in the following



Using the same external content type I have created an external list. When I was trying to access the external list I was getting the following error



Reason:

When you set the credentials for the Target Application ID in Secure Store Service Application you should give both the domain name and the user name (DomainName\UserName).

How to resolve:

1. Go to Central Administration => Application Management => Manage Service Applications => Secure Store Service Application.
2. Select the Target Application ID => Click on the down arrow => Select Set Credentials (I have created a target application id "BCS" and I was using the same for the external content type that I have created).
   
   
    
3. Set the credentials for the Secure store target application which should include both domain name and the user name (DomainName\UserName) as shown in the following