Re: using a certificate as login account
- From: "Remus Rusanu [MSFT]" <Remus.Rusanu.NoSpam@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 22 Mar 2006 12:08:45 -0800
No, it is not possible. What is possible is to log in into Windows using a
smartcard /certificate, then connecting to SQL Server using Windows
authentication.
The certificates stored in SQL Server can be used for code signing, for data
signing and encryption, for key encryption, for Service Broker
authentication. But they cannot be used for user login authentication.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"Peter" <Peter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0D3FDB0D-5D31-4C0E-A76F-3BEAD7AB1EB3@xxxxxxxxxxxxxxxx
In SQL Server 2005, is it possible to use a user certificate as login
account
rather than using SQL Server account or Windows account? If yes, how does
a
connection string look like?
Thanks
--
Peter
.
- Prev by Date: Re: Using same AD Security Group name for two different domains on MSSQL 2000
- Next by Date: Re: SQL Server 2000 Encryption
- Previous by thread: for some reason when i deploy my C# application on windows 2003 occasionaly rdr[0].ToString() hangs where rdr is a System.Data.SqlClient.SqlDataReader. Is there a fix for this? is my visual studio.net out dated?
- Next by thread: SQL Server 2000 transactional replication over SSL
- Index(es):
Relevant Pages
|
|
