To Fix this issue you will need to have access to ODBC Data Sources (32-bit) or (64-bit) if this is used with Admin Privileges.
Follow these steps to fix the issue:
Open ODBC Data Source Administrator (32-bit)
Select System DSN (User DSN is sometimes used for ODBC Connections too)
Find the ODBC Link you used (Example - Dimensions)
Click Configure
Ensure the details for the server are correct and press Next
Use the Password for the user under With SQL Server Authentication using a login ID and password entered by the user (Usually the SA user)
Click Next
Ensure that Use ANSI Quoted identifies Is ticked
Press Next
Press Finish
Press Test Connection
If successful try to log back into dimensions with the ODBC Link you just changed
Create the user again