ODBC Error Messages: Verifying that your credentials are correct
Symptoms are listed below:
you receive an authorization required error message, it is likely that there is a user authentication issue with your instance.
If you receive the following error message while using the ODBC driver,
[DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]Method failed:
(https://demo.service-now.com/sys_user.do?SOAP&displayvalue=all) HTTP/1.1 401 Authorization Required with code: 401, make sure that the credentials (user name/password) supplied in the login dialog are correct and that the user exists in the targeted instance.