SQL based AuthC/AuthZ for PXE Users

[junk1]

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.

[hslai]

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.

[junk1]

Thanks Hosuk. Will try and get back.

Regards

V Vinodh.