Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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

share|improve this question
    
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 '13 at 12:00

1 Answer 1

up vote 1 down vote accepted

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:

http://technet.microsoft.com/en-us/library/ee806889.aspx

http://technet.microsoft.com/en-us/library/ee806866.aspx

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.

share|improve this answer
    
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. –  SPNewbie Apr 5 '11 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. –  SPNewbie Apr 5 '11 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 '11 at 13:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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