Choose and configure the preferred method on the SQL Method tab.
Screen capture of the SQL Method tab showing the Table and Stored Procedure options.
Note:

This tab appears only when you specify Microsoft SQL Server datastore on the User Repository tab.