I'm using SPD 2010 to connect to an external SQL database hosted on a different server. External data source type selection is SQL Server. I then filled up the connection properties , choose "Connect with Impersonated Windows Identity" and Secure Store Application Id (which I created using this link). But SPD 2010 return this error: Cannot logon with credentials obtained from Secure Store Provider

I don't know how to fix this. Can somebody help please?!

Thanks, SPNewbie

  • I get the same error Cannot logon with credentials obtained from Secure Store Provider The username I provided can login to the database server and connect to the database using SQL management studio.Any inputs to help resolve this will be highly appreciated.
    – user13894
    Jan 4, 2013 at 12:00

1 Answer 1


You need to set up your Secure Store service application on the server, and add a Target Application. This is an arbitrary name you assign to the set of credential mappings that you will set up in the Secure Store.

To be honest, this is a non-trivial administration task and you probably need to understand a little about how the Secure Store works and is configured. The article you link is good; your next port of call will probably be TechNet:



Another good hands-on how-to article

Things to watch out for: Use a group mapping if you want a single set of credentials rather than give each user individual access to the back-end system. Make sure permissions to the ECT configured using the BCS service application. Make sure the account for which you create the credentials in the Secure Store actually has access to the back-end database.

Don't forget to check the ULS logs and the SQL logs and the event log on the machine hosting your service application.

  • I got this error: The Microsoft Secure Store Service application Secure Store Service failed to retrieve credentials. The error returned was 'Access is denied.'. For more information, see the Microsoft SharePoint Products and Technologies Software Development Kit (SDK). I followed the instructions on the link you gave me. Apr 5, 2011 at 12:15
  • Additional info: the db is located on a different server on a different domain and I can see the tables on the data source explorer on SharePoint Designer but there is an error when the external list is viewed on the browser. Apr 5, 2011 at 12:17
  • Make sure that the credentials that you set in the secure store have at least db_reader access to the database. Also make sure the user making the request is included in the members group for the target application (you'll see it greyed when you go to modify the credentials).
    – SPDoctor
    Apr 5, 2011 at 13:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.