I was wondering if besides the standard username/password ODBC authentication, other options exist to authenticate an ODBC connection using an alternate method like PKI similar to SSH.

Seems like a username / password not as secure if all I want is a server to server connection with no "real" user. It would seem more secure to have the DB server only accept connections from the app server.

  • What database server are you using? Several DBMS support authentication via certificate. – Zoredache Aug 25 '10 at 17:30
  • MS SQL, Oracle, etc. I am not the DBA, just a curious user. Is there info out there on DBs that support certificate auth? – noel_g Aug 25 '10 at 17:32
  • 1
    I suspect you will need to consult the vendor documentation for your favorite DBMS. – Zoredache Aug 25 '10 at 19:04
  • seems like the key to this is X509. if the DB supports taht then you can do the cert based auth. Thanks – noel_g Aug 26 '10 at 0:02

Yes, there are other authentication methods.

Most DBMS-supplied "native" data access drivers (ODBC, JDBC, ADO.NET, OLE DB, XMLA, and others) are limited to UID/PWD.

MySQL (and possibly others) checks the client hostname and/or IP address as well as username and password.

Some third-party data access drivers like the ones from my employer add other authentication methods -- such as WebID, which leverages X509 technologies -- and attributes of the connection -- including but not limited to client IP address, application, operating system, and others.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.