Once you install, you cannot change the user manager without reconfiguring the product. If you installed with AD and need to now use SQL as your user manager, you must disable or remove AD from your environment and then rerun the Setup Manager. When AD is not detected, the Setup Manager allows you choose SQL as the user manager. If you rejoin a domain and have AD in the environment again, run the Setup Manager to reconfigure the product.

After you install the product with either Active Directory or SQL as the default user manager, you can configure more user managers. You can control which user managers can be used to log in to the system by checking the Use for Login option on your claims issuer. If you only have one issuer marked as Use for Login, users logging into the system do not have a choice for using a different user manager to login.
You can find information about configuring this in the in the Management Claims and Issuers topics in the User Guide.