手冊:Microsoft SQL Server

From MediaWiki.org
Jump to navigation Jump to search
This page is a translated version of the page Manual:Microsoft SQL Server and the translation is 60% complete.
Other languages:
English • ‎中文 • ‎日本語
手册:目录 MediaWiki数据库布局 Microsoft SQL Server/zh


警告 警告: Oracle与Microsoft SQL Server的支持不再维护并将在MediaWiki 1.34中移除。 强烈建议你不要使用它们。

MediaWiki对Microsoft SQL Server的支持还处于实验性品质。 一般来说,使用这个数据库时所有wiki特性都能正常工作,然而可能存在一些问题影响使用某些常用功能。 所有关于Microsoft SQL Server的已知问题都在MSSQL项目中跟踪。 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.

服务器需求

Microsoft SQL Server 2008 R2 or later and Microsoft Azure SQL Database are supported, however running the latest version of SQL Server is recommended. 不支持Express版。

客户端需求

PHP必须安装和启用sqlsrv扩展。

安装

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 db_datareader and db_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.