March 28, 2018 at 6:39 am
I am running SQL Server 2014 SP2 CU8 on Windows Server 2012.
The network team enabled “Smart card is required for interactive logon” in Active Directory - once enabled we could no longer connect to our SQL Instance via SSMS.
The way I am currently using SSMS is when I open SSMS Right Click – Run As Different User and use a Smart card to log in. This makes SSMS use administrator level accounts to authenticate when using Windows Authentication.
Our administrator level accounts can no longer authenticate because smart card is required.
Is there a way that SQL Server can use Smart Card to authenticate. We are currently using SSMS 2014. Is there a windows setting that would allow a pass through to SQL Server of some type?
Does a newer version of SSMS support SMART Card Authentication?
Any information would be appreciated.
Jeff
March 28, 2018 at 6:59 am
My employer requires smart cards for login, and it works fine.
You should be able to add your AD login as a login in SQL, then just start SSMS (without doing the "Run As") and connect.
If your admin-level accounts are still set to username / password, and the AD team enabled smart card logins for those, then they should provide you with a second card tied to those accounts, after which you could still do the "Run As" and choose the admin card as the login.
As a note, SQL itself, other than SQL logins, relies on the OS to handle authentication of a login, whether it be a local to the server Windows login, or an Active Directory login, so *technically* SQL does not "support" SMART card authentication, the OS does.
March 28, 2018 at 8:23 am
Thank you for the reply. The information is good.
Jeff
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply