I am facing an issue with the connection with OLEDB to MS sql server.
Please find the attached screen shot and suggest how to resolve the issue.
Thanks in advance.
Have you confirmed that the user has appropriate permissions to read / select from the db?
Can you also try logging in with an administrative user-id and password??
Your current screen shots shows you are using a windows authentication......which depends on the window user profile you are on....
Try like this. Hope it will help you.
Please try with above settings and let me know if any issues.
Retrieving data ...