Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1117
  • Last Modified:

external data invalid credentials

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
invalid.jpg
set-permission.jpg
0
AZZA-KHAMEES
Asked:
AZZA-KHAMEES
  • 2
  • 2
1 Solution
 
BudDurlandCommented:
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?
0
 
David Johnson, CD, MVPOwnerCommented:
you need to give sharepoint the appropriate permsisions as it is running in that context and not in your user context
0
 
AZZA-KHAMEESAuthor Commented:
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?
0
 
David Johnson, CD, MVPOwnerCommented:
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.
0
 
AZZA-KHAMEESAuthor Commented:
could you please tell me how to give sharepoint appropriate permission ? cuz i am already a biggner in sharepoint 2010
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now