I'm trying to get some data from external content type from SQL server by using my windows identity, but when I add a new connection in SPD, and choose user's identity to connect, a error message pop up stating this:
I confirmed there were no typo in sever name and DB name as I used them in data source page(I was able to add my SQL server as a data source with a user's sql login).
I confirmed my windows identity has permission to access my SQL server since I was able to log in to SQL server management studio and view tables with my windows authentication.
So, what's potentially causing this problem, and how should I troubleshoot/fix it? Thank you!