July 17, 2014 at 9:35 am
Dear friends,
I have create a login which is mapped to a certificate. But I am not able to login to the sql server using the same login in SSMS. Can anyone explain how to use that login which is mapped to certificate?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
July 17, 2014 at 11:02 am
You can't login using that login. Certificate based logins are designed to be used when signing a module (Procedure/function) that does a task that requires elevated permissions that you do not want to grant to a real user/login. This is a good blog post (even though it is for SQL Server 2005) that helps explain it, http://blogs.msdn.com/b/lcris/archive/2005/06/15/429631.aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 19, 2014 at 7:02 am
Thanks jack
Ryan
//All our dreams can come true, if we have the courage to pursue them//
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply