Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OS authentication using Microsoft certificate store

user-0tm03May 11 2023 — edited May 11 2023

Trying to connect to a remote database with os authentication which works via SQLDeveloper but not in VSCode with the Oracle developer tools extension. In the new connection settings, using tns alias connection type, I can select my desired tns alias so it's finding my tnsnames.ora file. For user name I do use the ‘/’ as docs say. I leave wallet file location unchecked, and its default location is where my tnsnames.ora and sqlnet.ora files reside. When I select the create connection button, it brings up the Windows Security dialog where one usually selects their desired certificate, however none of my certificates are shown, only the message “select smart card device” and the list of smart card devices on my system. I feel this is related to the mcs configuration line in the sqlnet.ora file. Any suggestions?

sqlnet.ora does contain the following lines needed:
SQLNET.AUTHENTICATION_SERVICES=(TCPS,NTS)
WALLET_LOCATION=(SOURCE=(METHOD=mcs))

Versions:
Windows 10
VS Code 1.78.1
Oracle developer tools for VS Code 21.5.0

NOTE: Using the same tnsnames.ora and sqlnet.ora configuration, SQLDeveloper works properly, and shows my list of certificates to select from in the Windows Security dialog and I can establish connection using my selected certificate. Versions: SQLDeveloper 22.2.0 and Instant Client 21.10 64 bit.

Comments
Post Details
Added on May 11 2023
3 comments
508 views