Extension:MS SQL Database Authentication

This MediaWiki extension authenticates users and gets users data using external Microsoft SQL Server database. The extension is indispensable, if you need, for example, to grant access to your wiki only to some employees of your company, or to some students of your university listed in some SQL Server database table.

Installation & Configuration
This extension requires Microsoft Drivers for SQL Server for PHP to be pre-installed.

Download the extension. Unzip and save the files into  subdirectory of your wiki's   directory.

All configuration settings must be specified in global variables in MediaWiki's LocalSettings.php file. Here are the settings and their description:

Use MS SQL database for authentication only, ignore users in MediaWiki database MS SQL Server Host Name. IP address, domain or instance name can be specified, or. MS SQL Server Username. Set this to  or empty value   to use Windows Authentication to connect to SQL Server. MS SQL Server Password. Set this to  or empty value   in case of Windows Authentication. MS SQL Server Database Name MS SQL Server Database Table Containing Users Data. Schema can be specified if required, e.g. Username Field in the table. Note that MediaWiki automatically capitalizes the first letter of username. Maybe you should consider switching this table field to case-insensitive collation. Password Field Password Field Hashing Algorithm,  means password in plain text. User's Email Field User's Real Name Field PHP Driver to connect to MS SQL Server Path to extension's MsSqlAuth.php file, relative to MediaWiki installation The following last line must be unmodified, just copy it

Look at the screenshot of sample database which was created to suit settings specified above.

That's it!

Feedback
If you would like to report a bug or request a feature, you can do it on discussion page or on SourceForge. By the way, if you need advanced bot functionality for your wiki project, take a look at free DotNetWikiBot Framework, that I maintain..

MediaWiki 1.39.x LTS Test Plan
The items listed here are general issues related to MediaWiki 1.39.x LTS. They are not addressing any issues that are specific to this extension.


 * Extension considered active for MediaWiki 1.30.x LTS