up vote 1 down vote favorite
share [g+] share [fb]

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

link|improve this question
67% accept rate
feedback

1 Answer

up vote 0 down vote

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.

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

Your Answer

 
or
required, but never shown
discard

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