₦airaland Forum

The error reason An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. can be returned in the following situation:
When the server is configured for mixed mode authentication, and an ODBC connection uses the TCP protocol, and the connection does not explicitly specify that the connection should use a trusted connection. To resolve this issue, include TRUSTED_CONNECTION = TRUE in the connection string or you can fix sql server error here: https://www.repairtoolbox.com/sqlserverrepair.html