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

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

1 Answer 1

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.

share|improve this answer
Yes, I'm still interested in an answer. Thank you. –  Stephane Jun 7 '11 at 13:14

Your Answer


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

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