Having problems connecting to SQL Server.
Login failed for user ”. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: w.x.y.z]
Ensure that you have the right authentication selected.
In our case, we are using ODBC and so we have to be aligned in two places; the ODBC Connection Manager and the Application Database Configuration Settings/String.
Authentication – SQL
Authentication – Windows
Unfortunately we were trying to use Windows Authentication and we configured the Application to do so.
But, our ODBC Setting was still configured to use SQL Authentication.