Microsoft SQL Server

This page is a translated version of the page Manual:Microsoft SQL Server and the translation is 50% complete.
Manuel:Contenu Schéma de la base de données MediaWiki Microsoft SQL Server/fr
Depuis la version 1.34 , MediaWiki ne prend plus en charge l'utilisation de Oracle ni de Microsoft SQL Server .

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 had been supported from MediaWiki 1.23 to MediaWiki 1.33, and was best supported on the LTS releases of MediaWiki. Non-LTS releases have diminished support, and the database may not work at all on them.

Contraintes du serveur

Microsoft SQL Server 2008 R2 or later and Microsoft Azure SQL Database are supported; however, running the latest version of SQL Server is recommended. Les éditions Express ne sont pas prises en charge.

Contraintes du client

L'extension PHP sqlsrv doit être installée et activée.

Installation

Follow the prompts in the installer to install MediaWiki on Microsoft SQL Server. Vous pouvez soit créer une nouvelle base de données pendant l'installation ou utiliser une base existante. 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). L'utilisateur de la base de données pour les opérations wiki normales doit avoir les droits db_datareader et db_datawriter. 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.