SQL Server Fails - Username or Password is Wrong

4. Adding a SQL Server fails with error message "The given Username or Password is wrong. Please configure with correct values"

Reason  : The SQL Server Authentication mode is not enabled in SQL Server
Solution : To enable SQL Server Authentication mode in SQL Server Management Studio Object Explorer, open Server Properties > Security > select SQL Server and Windows Authentication mode ( Mixed mode ) there. After you have changed the configurations, restart the SQL Server for the settings to take effect.
Note : Mixed mode is not required if you add the SQL Server using Windows Authentication in SQLDBManager Plus