Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have to connect an (ADO) application running on a standalone Windows 2003 R2 server to a SQL 2008 R2 database that is a member of the domain.

I have setup an SQL authentication account for this and hard-coded the password into the connection string but I wonder if it wouldn't be possible to use certificate-based authentication for this instead. I haven't been able to find any documentation regarding this apparently new functionality of SQL 2008 R2 anywhere.

Could someone kindly point me at some good documentation ? Or at least a description of the functionality and whether it could be used in my case or not ?

Thank you in advance

share|improve this question
If you still want help with this, let me know. I have some scripts to create and use SQL Certificate Objects for mirroring purposes in a workgroup situation, that would probably work the same way for your situation. – Snoi May 31 '11 at 23:48
Yes, I'm still interested in an answer. Thank you. – Stephane Jun 7 '11 at 13:14
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post - you can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post. – Falcon Momot Oct 2 '15 at 21:11

Your Answer


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

Browse other questions tagged or ask your own question.