I plan to create a Joomla! website for a company. They maintain their client database on a separate MS SQL box. They want to use the website as front end for registration and login.
Tasks To be Achieved:
- Users will be registered into an external MS SQL database when they register at the website's Register module, and IT Manager receives these information.
- Account verification and approval will be sent to the user by the company IT Manager.
- When the Login button at the website is selected, the UserID/Password is validated against MS SQL Database, and if it is valid then the user is automatically redirected to an external application URL.
- Users can retrieve username / passwords from the website link
Could you please help me to achieve these tasks?
I really appreciate your help.