Tuesday, October 8, 2013

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. But SPD
2010 returns this error: Cannot logon with credentials obtained from
Secure Store Provider

Error message:

Cannot logon with credentials obtained from Secure Store Provider

We 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 but
getting the same error.

Troubleshooting done:

I made
sure that the credentials that i set in the secure store have at least
db_reader access to the database.

Also ensured the user making the request is a part of members
group for the target application.

Checked the ULS logs and did not find anything relevant.

Suspecting that there is some sort of firewall or VPN issue but,
I am not sure how to proceed?

Tried with different account rather than system account to
ensure it reflects the same set of results.

Referred the following articles again n again to make sure
everything set up correctly but did not yield any results!