Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
    
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.