SQL server support only SQL & windows authetication.
To use CAC access for SQL server you need to look for application devlopers who can pass you CAC credentails to SQL server as a login.
Please click the Mark as Answer or Vote As Helpful if a post solves your problem or is helpful!