external data invalid credentials

Posted on 2011-10-05
Last Modified: 2012-05-12
Hi expert, i created and extenal data to access another database in sql, and every thign is working fine, but when i reu the list to get the data i am getting the following error
"external data invalid credentials"
note that i have full permission on this service as show in the attached images

can you help me
Question by:AZZA-KHAMEES
    LVL 17

    Expert Comment

    It looks like invalid credentials to the SQL service.  Are you (or the service process accessing the data) configured with appropriate rights to the SQL database server & database tables?
    LVL 77

    Accepted Solution

    you need to give sharepoint the appropriate permsisions as it is running in that context and not in your user context

    Author Comment

    Thank you for your replies, where can i specify the sharepoint permission? i created Secure Service Application and i specified my name in the permission but its still not working, so where can i specify the sharepoint permission?
    LVL 77

    Expert Comment

    by:David Johnson, CD, MVP
    does the sql server allow connections over tcp/ip ?? it is normally turned off.

    permissions will be in the web.config where your connectionstring resided.

    Author Comment

    could you please tell me how to give sharepoint appropriate permission ? cuz i am already a biggner in sharepoint 2010

    Featured Post

    Integrate social media with email signatures

    Is your company active on social media? Do you also use email signatures? Including social media icons in your email signature is a great way to get fans for free. Let all your email users know you’re on social media quickly and easily, in a single click.

    Join & Write a Comment

    Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    26 Experts available now in Live!

    Get 1:1 Help Now