I need to login to MS Sql from ODBC to my MS Sql instance on Linux server. Following are my question
Is there a way to do it without Active Directory (maybe with LDAP or ADLDS if it does not change user profile)?
I created a SQL Server Login without password by deselecting
enforce password policy. I can finish adding ODBC and Test Connection is successful, but when I run the program it gives an error the the login has failed and in the SQL Server Log it shows:
Login failed for user 'gp'. Reason: Password did not match that for the login provided".
The program I am running is a old program and I don't have the source code to change anything in it. Currently it works with Windows Authentication on a server running Windows Server and Microsoft SQL Server.