Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scotcro
Starting Member
2 Posts |
 Posted - 2009-09-21 : 11:05:22
|
| Can anyone tell me if there is a way to use a Login Certificate in an ADO Connection string?I am working on a Client Server Application that will access a hosted sql server in a collocation from various clients. Integrated Security is not an option, but I would like to eliminate discrete passwords.Thanks in advance for any help!s.s. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-09-21 : 16:59:44
|
| what do you mean login certificate ? Do you mean ssl ??? |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-09-22 : 11:39:23
|
| Logins can be created to login with a certificate, as opposed to a password, or Windows Authentication. So far, I have only seen this used in Database Mirroring across untrusted domains. I have not yet seen if SQLNCLI can log in using a certificate, so I can not prove that it can be done. But the documentation does not seem to mention using certificates as an option. It may be I am concentrating on the ADO or OLEDB like sections of the documentation, though. |
|
|
|
scotcro
Starting Member
2 Posts |
Posted - 2009-09-22 : 13:35:22
|
| This is the basis of my question... it would seem that you can use a certificate rather than a password, but I sure can fine out how. There is quite a bot of info on using a certificate for creating and endpoint for web service dialogue and mirroring.over on SQL Server Central Brian Keyy did an article that would indicate it is possible also. http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/sqlserver2005logins/2474/here is an excerpt:"Certificates and Asymmetric Keys If a certificate or asymmetric key is stored within SQL Server 2005, it can be used as a login. SQL Server 2005 isn't the first such application to allow logins using these sources. There have been 3rd party products which allowed the use of a smart card to log on to Windows and other operating systems for years now. An example of this would be the US Military's Defense Message System which used the US National Security Agency's Fortezza card. In addition, some products, such as HP's System Insight Manager, tends to use certificates for connections between systems. Certificates and asymmetric keys aren't used very heavily as logins as of yet with respect to SQL Server 2005 and as this is a "basics" article, I'll postpone discussion of their use as logins to a later article."Unfortunately I could not find any follow up articles that covered this.s. |
|
|
|
|
|
|
|
|
ADO Connection to Colocated SQL Server 2005 using