[SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Cannot connect to the instance. [dataSource=2288219503944] [user=odbc_user]You are not authorized to perform this operation. Please verify your credentials and try again.[1001]

[Tracy Li Gao]

The user odbc_user can login my PDI, and have given the role odbc.

I tried to install ServiceNow-ODBC-64-bit_1.0.15.exe, when PDI has been started about 2 mins, clicks "Test Connect" in ODBC 64 bit, it shows connected successful.

Then several mins later, would get error when clicking "Test Connect" in ODBC:

[SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Cannot
connect to the instance. (dataSource=2366386112856)
[user—odbc user]You are not authorized to perform this operation.
Please verify your credentials and try again.[1001]

Run command "connect odbc_user*password@servicenow;", get the output as attached.

Why connect successful at first 1-2 mins, then failed later? How to resolve the issue?

Please help to provide your suggestions next.

[Tracy Li Gao · Accepted solution]

I have installed ServiceNow-ODBC-32-bit_1.0.15.exe at first, then have it uninstalled as there is error could not be resolved, there is dirty data in ODBC Data Sources (32-bit) > tab System DNS > a line for Driver "ServiceNow ODBC Driver 32-bit"

I follow up below steps to remove the dirty data in ODBC Data Sources (32-bit), and reinstall ServiceNow-ODBC-64-bit_1.0.15.exe, and the issue resolved.

1. Uninstall ServiceNow-ODBC-64-bit_1.0.15.exe
2. Install ServiceNow-ODBC-32-bit_1.0.15.exe
3. Go to ODBC Data Sources (32-bit), tab System DNS > remove the line for Driver "ServiceNow ODBC Driver 32-bit"
4. Uninstall ServiceNow-ODBC-32-bit_1.0.15.exe
5. Install ServiceNow-ODBC-64-bit_1.0.15.exe
6. Go to ODBC Data Sources (64-bit), tab System DNS > click and configure the line for Driver "ServiceNow ODBC Driver 64-bit"