We have a desktop application, which connects to SQL server 2019 hosted in Azure using a generic user name and password. This connection works perfectly when the application is executed from Windows 10.
But the same application is not working when executed from Windows 7. In SQL error logs we noticed, It ignores the user name provided, instead it picks up the user who executes this application (Windows authentication) and validates their access to the database. In our case users don't have access to the DB. Hence it is failing.
Please clarify, why it ignores the user name provided and why it expects the Windows authentication here?
Error from SQL Error log: 04/01/2021 14:16:31,MSSQL$SQLPRDXXXX ,Audit Failure,Login failed for user 'NMPC\abcde'. Reason: Token-based server access validation failed with an infrastructure error. Login lacks Connect SQL permission. [CLIENT: IP address],(4),18456,NMPC\abcde,DB SERVER Name.