Authenticate phpBB using custom MS-SQL database

How can I let my users to log into a phpBB forum by entering their user credentials while these credentials are stored in a separate MS SQL database?

  • SQL Server: permissions to read database diagrams
  • Error : When Using SqlDependency Without Providing an Options Value
  • SQL server select distinct rows using most recent value only
  • Whats wrong with this SQL statement for table variable bulk insert
  • Select performance
  • Sum hierarchical values in table for Continent, countries and states
  • PHP connect to SQL server with a windows account
  • delete physical file after deleting the record of a table in database
  • Run Microsoft .SQL file in PHP
  • Connecting to MSSQL server 2008 with PHP
  • MSSQL Server's Native ODBC Driver for Linux and PHP 5.4
  • Problem printing MSSQL datetime to html using PHP (sqlsrv extension)
  • One Solution collect form web for “Authenticate phpBB using custom MS-SQL database”

    You need to create a custom authentication plugin for phpbb. Since your requirement is authentication against a database, it should be pretty straight forward to re-use the existing plugin phpbb uses for authentication against it’s own internal database.

    Authentication plugins are located in <install_dir>/includes/auth

    An authentication plugin must be named auth_<your custom name>.php

    So in your case, create a copy of auth_db.php and call it e.g. auth_mssql.php

    Authentication plugins are documented here:

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.