how to login in sql server with certification login

hi all,

i have created a login account using certificate.

--CREATE A CERTIFICATE--

CREATECERTIFICATE TEST_CERTIFICATE123

WITH SUBJECT ='CERTIFICATE IN TEST DATABASE',

START_DATE='06/04/2007',

EXPIRY_DATE ='02/02/2009';

GO

--CREATE LOGIN FRON THE CERTIFICATE

CREATELOGIN LALIT12301 FROMCERTIFICATE TEST_CERTIFICATE123;

GO

How can i use this login credential to login to microsoft sql server management studio.It is askin only for sql/windows authentication.There is no option for the certificate based login.

if i m passing this login id as sql server authentication then i m getting following error.

Login failed for user 'LALIT123'. (Microsoft SQL Server, Error: 18456)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

please do help me.....

It is not currently possible to login to SQL Server as a certificate Login.

These kinds of logins are used for signed modules and allow some finer grained access control to pieces of code because you can grant permissions to the certificate login, sign a procedure with the certificate and anyone who has execute permission on the procedure will have the additional permissions granted to the certificate login WHILE the procedure is executing.

HTH,

-Steven Gott

SDE/T

SQL Server

|||

Hi Steven

Thanks a lot..............