 | This page is obsolete. It is being retained for archival purposes. It may document extensions or features that are obsolete and/or no longer supported. Do not rely on the information here being up-to-date. |
Microsoft SQL Server support on MediaWiki is of experimental quality.Generally, all wiki features should work using the database, however there may be issues blocking usage of some common features.All known bugs with Microsoft SQL Server are tracked usingthe MSSQL project.Microsoft SQL Server had been supported from MediaWiki 1.23 to MediaWiki 1.33, and was best supported on theLTS releases of MediaWiki.Non-LTS releases have diminished support, and the database may not work at all on them.
Microsoft SQL Server 2008 R2 or later andMicrosoft Azure SQL Database are supported; however, running the latest version ofSQL Server is recommended.The Express editions are not supported.
PHP must have thesqlsrv extension installed and enabled.
Follow the prompts in the installer to install MediaWiki on Microsoft SQL Server.You can either create a new database during installation or use an existing one.The installation user should have thedbowner role for the database (if using an existing database) or the sysadmin role (if creating a new database).The database user for normal wiki operation should have thedb_datareader anddb_datawriter roles.If creating a new database user as part of the installation, it will be granted the minimum set of permissions needed in order to make the wiki functional.