Link to home
Create AccountLog in
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Avatar of AZZA-KHAMEES
AZZA-KHAMEES🇧🇭

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

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Avatar of Bud DurlandBud Durland🇺🇸

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?
ASKER CERTIFIED SOLUTION
Avatar of David Johnson, CDDavid Johnson, CD🇨🇦

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of AZZA-KHAMEESAZZA-KHAMEES🇧🇭

ASKER

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?
Avatar of David Johnson, CDDavid Johnson, CD🇨🇦

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.
Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

Avatar of AZZA-KHAMEESAZZA-KHAMEES🇧🇭

ASKER

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

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.