Manual:Microsoft SQL Server
|↑ Manual:Contents||MediaWiki database layout||Microsoft SQL Server|
|Warning:||Oracle and Microsoft SQL Server support are unmaintained and will be dropped in MediaWiki 1.34. You are strongly advised against using them.|
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 using the MSSQL project. Microsoft SQL Server has been supported since MediaWiki 1.23, and is best supported on the LTS releases of MediaWiki. Non-LTS releases have diminished support, and the database may not work at all on them.
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 the
dbowner 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 the
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.