05-14-2018 02:39 AM
Hi
My customer currently allow access to PXE endpoints to DNS/AD/MDT servers via Pre-Auth ACLs in switches.
They are looking for a solution with Microsoft SQL DB where - ISE integrated with Ms SQL, a table is created with MAC addresses who need access to DNS/AD/MDT servers.
When endpoint is connected, ISE checks if the entry is available in SQL DB and if yes, authorise that endpoint with DNS/AD/MDT servers access.
Please validate if this logic works.
If yes, please confirm what procedures should I write in SQL DB from ISE side, which attribute should I map.
Please help here with the configuration.
Thanks and Regards
V Vinodh.
05-14-2018 06:07 AM
ODBC Identity Source supports as ID source for MAB.
See Configure ISE 2.1 with MS SQL using ODBC and we may either configure the MAC addresses as both username and password or the stored procedure to do so.
05-15-2018 09:53 AM
Thanks Hosuk. Will try and get back.
Regards
V Vinodh.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide