topic Re: SQL based AuthC/AuthZ for PXE Users in Network Access Control https://community.cisco.com/t5/network-access-control/sql-based-authc-authz-for-pxe-users/m-p/3492819#M509985 <HTML><HEAD></HEAD><BODY><P><A href="https://www.cisco.com/c/en/us/td/docs/security/ise/2-1/release_notes/ise21_rn.html#pgfId-677960">ODBC Identity Source</A><SPAN style="font-size: 10pt;"> supports as ID source for MAB.</SPAN></P><P><SPAN style="font-size: 10pt;">See <A href="https://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-21/200544-Configure-ISE-2-1-with-MS-SQL-using-ODBC.html?referring_site=RE&amp;pos=1&amp;page=https://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-22/210521-Configure-ISE-2-2-for-integration-with-M.html">Configure ISE 2.1 with MS SQL using ODBC</A> and we may either configure the MAC addresses as both username and password or the stored procedure to do so.<BR /></SPAN></P></BODY></HTML> Mon, 14 May 2018 13:07:29 GMT hslai 2018-05-14T13:07:29Z SQL based AuthC/AuthZ for PXE Users https://community.cisco.com/t5/network-access-control/sql-based-authc-authz-for-pxe-users/m-p/3492818#M509983 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>My customer currently allow access to PXE endpoints to DNS/AD/MDT servers via Pre-Auth ACLs in switches. </P><P>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 <SPAN style="font-size: 13.3333px;">DNS/AD/MDT servers. </SPAN></P><P><SPAN style="font-size: 13.3333px;">When endpoint is connected, ISE checks if the entry is available in SQL DB and if yes, authorise that endpoint with <SPAN style="font-size: 13.3333px;">DNS/AD/MDT servers access. </SPAN></SPAN></P><P>Please validate if this logic works.</P><P>If yes, please confirm what procedures should I write in SQL DB from ISE side, which attribute should I map. </P><P>Please help here with the configuration.</P><P></P><P>Thanks and Regards</P><P>V Vinodh.</P></BODY></HTML> Mon, 14 May 2018 09:39:41 GMT https://community.cisco.com/t5/network-access-control/sql-based-authc-authz-for-pxe-users/m-p/3492818#M509983 junk1 2018-05-14T09:39:41Z Re: SQL based AuthC/AuthZ for PXE Users https://community.cisco.com/t5/network-access-control/sql-based-authc-authz-for-pxe-users/m-p/3492819#M509985 <HTML><HEAD></HEAD><BODY><P><A href="https://www.cisco.com/c/en/us/td/docs/security/ise/2-1/release_notes/ise21_rn.html#pgfId-677960">ODBC Identity Source</A><SPAN style="font-size: 10pt;"> supports as ID source for MAB.</SPAN></P><P><SPAN style="font-size: 10pt;">See <A href="https://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-21/200544-Configure-ISE-2-1-with-MS-SQL-using-ODBC.html?referring_site=RE&amp;pos=1&amp;page=https://www.cisco.com/c/en/us/support/docs/security/identity-services-engine-22/210521-Configure-ISE-2-2-for-integration-with-M.html">Configure ISE 2.1 with MS SQL using ODBC</A> and we may either configure the MAC addresses as both username and password or the stored procedure to do so.<BR /></SPAN></P></BODY></HTML> Mon, 14 May 2018 13:07:29 GMT https://community.cisco.com/t5/network-access-control/sql-based-authc-authz-for-pxe-users/m-p/3492819#M509985 hslai 2018-05-14T13:07:29Z Re: SQL based AuthC/AuthZ for PXE Users https://community.cisco.com/t5/network-access-control/sql-based-authc-authz-for-pxe-users/m-p/3492820#M509995 <HTML><HEAD></HEAD><BODY><P>Thanks Hosuk. Will try and get back.</P><P></P><P>Regards</P><P>V Vinodh.</P></BODY></HTML> Tue, 15 May 2018 16:53:18 GMT https://community.cisco.com/t5/network-access-control/sql-based-authc-authz-for-pxe-users/m-p/3492820#M509995 junk1 2018-05-15T16:53:18Z