Answers.Body: <p>Assuming you're running Craft CMS 3, the <a href="https://github.com/nystudio107/craft-connect" rel="nofollow noreferrer">Connect plugin</a> will let you connect to MSSQL databases (local or remote)</p>
  
  <p>You'll just need to do:</p>
  
  <pre><code>composer require yiisoft/yii2-mssql
  </code></pre>
  
  <p>...on your Craft CMS project. To be clear, this doesn't add support for MSSQL to Craft itself, it just lets you query MSSQL databases in your Twig templates.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-08-15T19:45:23.950Z
Answers.LastActivityDate: 2018-08-15T19:45:23.950Z
Answers.UserDisplayName: andrew.welch
Answers.Body: <p>Craft 3 supports <a href="https://docs.craftcms.com/v3/requirements.html#server-requirements" rel="nofollow noreferrer">MySQL 5.5+ and PostgreSQL 9.5+</a>.</p>
  
  <p>Craft 2 only supports <a href="https://docs.craftcms.com/v2/requirements.html" rel="nofollow noreferrer">MySQL 5.1+</a>.</p>
  
  <p>Yii (the framework Craft runs on) uses <a href="https://secure.php.net/manual/en/book.pdo.php" rel="nofollow noreferrer">PDO</a> for its database abstraction layer, which supports <a href="https://secure.php.net/manual/en/pdo.drivers.php" rel="nofollow noreferrer">many databases</a>, so technically it wouldn't be much work but it's more of a matter of the demand for it and "are we ready to support other databases".</p>
  
  <p>Logically MSSQL would probably be next on the list, but there's not timeline/ETA for it.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2016-03-11T00:28:07.813Z
Answers.LastActivityDate: 2018-08-15T19:45:54.193Z
Answers.LastEditDate: 2018-08-15T19:45:54.193Z
Answers.UserDisplayName: Brad Bell
Body: <p>Is there a MSSQL support for Craft CMS?
  Or any plugin that can help to connect to a MSSQL database?</p>
  
  <p>Thank you!</p>
  
Tags: <database>
Title: MSSQL Support for Craft?
ThreadText: # MSSQL Support for Craft?
  
  (Asked by: username_0 on 2016-03-11)
  
  Is there a MSSQL support for Craft CMS?
  Or any plugin that can help to connect to a MSSQL database?
  
  Thank you!
  
  **Tags:** database
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2018-08-15. Score: 3
  
  Assuming you're running Craft CMS 3, the [Connect plugin](https://github.com/nystudio107/craft-connect) will let you connect to MSSQL databases (local or remote)
  
  You'll just need to do:
  
  ```
  composer require yiisoft/yii2-mssql
  
  ```
  
  ...on your Craft CMS project. To be clear, this doesn't add support for MSSQL to Craft itself, it just lets you query MSSQL databases in your Twig templates.
  
  
  ---
  
  ### Answer by username_2 on 2016-03-11. Score: 2
  
  Craft 3 supports [MySQL 5.5+ and PostgreSQL 9.5+](https://docs.craftcms.com/v3/requirements.html#server-requirements).
  
  Craft 2 only supports [MySQL 5.1+](https://docs.craftcms.com/v2/requirements.html).
  
  Yii (the framework Craft runs on) uses [PDO](https://secure.php.net/manual/en/book.pdo.php) for its database abstraction layer, which supports [many databases](https://secure.php.net/manual/en/pdo.drivers.php), so technically it wouldn't be much work but it's more of a matter of the demand for it and "are we ready to support other databases".
  
  Logically MSSQL would probably be next on the list, but there's not timeline/ETA for it.
  
  
  ---
  
  