Jump to content

Manual:마이크로소프트 SQL 서버

From mediawiki.org
This page is a translated version of the page Manual:Microsoft SQL Server and the translation is 6% complete.
Manual:컨텐츠 MediaWiki database layout Microsoft SQL Server/ko
미디어위키는 버전 1.34 부터 오라클 마이크로소프트 SQL 서버 사용을 더 이상 지원하지 않습니다.

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.

Server requirements

Microsoft SQL Server 2008 R2 or later and Microsoft Azure SQL Database are supported; however, running the latest version of SQL Server is recommended. The Express editions are not supported.

Client requirements

PHP must have the sqlsrv extension installed and enabled.

Installation

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.