I am new to SQL area, it might be very simple, but googling did not help so far. Your help much appreciated.
I am trying to connect the database to see the live data of a particular table via a program. First, I want to test via excel database connection to verify username and permissions are set correctly. So far, I am not succeeded. (Please note, I can connect using the sa account or windows authentication with full permissions, which we don't want for known reasons). Looking at the below screenshot and details, could you tell me what I am missing, please?