Message from External System Login Failed for user ....

Message from External System Login Failed for user ....


When we are trying to create an External Content type with SharePoint Designer we will face an issue some thing like Message from External System Login Failed for user ... In order to fix it follow the below steps,.

Solution :

Click on Add Connection - > Select  second option Connect with impersonated Windows Identity

and provide Secure Store Application Id which was created in Central Admin to connect external system and Click on Ok button

select the option as per your requirment by Right clicking on Students table

Access denied by Business Data Connectivity.

Access denied by business data connectivity when creating external content type

Solution :

Go to Central Administration -> Manage Service Applications -> Business Connectivity Service application

Select the External Content type which you have created, and click on Set Object Permissions button in the ribbon,

In my case its NewExternal content type.

Type EveryOne and click on Add button and Select Execute Check box and Click on OK Button

That's set..., you will be able to see the result , if still getting same error select Edit checkbox and try it.