Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Install
Works with Drupal: 7.xUsing Composer to manage Drupal site dependencies
Downloads
Download sqlsrv-7.x-1.1.tar.gztar.gz
21.65 KB
MD5: 467117291b8638d667a9862ac8e1699e
SHA-1: ff482e2e3966dae9d0d1f8c3e87dd3473f7fdd4f
SHA-256: 905207d44f93a6465d24f4d7506ea1c19c52eb5218736e48186a58f579c5ee90
Download sqlsrv-7.x-1.1.zipzip
25.55 KB
MD5: 7349bc484574275a258033a940e4ba02
SHA-1: 7bbaf29bacaf097763649ef5c3b2b3a72fdc1faa
SHA-256: 5b267e57b394319f2dc3b8da3d0ef6dd73bba6c614d5b27850802c4785a06950
Release notes
Updated release for Drupal 7.4
.
Changes since 7.x-1.0:
Installation instructions
IIS and Drupal
Set up your IIS server in the configuration recommended by Drupal (using the URLRewrite module). Drupal 7 now ships with a web.config file, which should make that easy.
PHP driver for SQL Server
Install the PHP SQL Server Driver 2.0 from Microsoft.
Drupal and the SQL Server driver
Uncompress Drupal in the web root. Uncompress this driver as sites/all/modules/sqlsrv
, and copy or link the sqlsrv
directory found inside it in includes/databases
.
Initial database set up
- Create a SQL Server database for Drupal. Both SQL Server (full edition) and SQL Server Express are supported. The database must be created using a unicode case-insensitive collation (for example the default SQL_Latin1_General_CP1_CI_AS).
- Install Drupal has you normally would, selecting
SQL Server
in the database option list. - When you are prompted for the hostname, enter the SQL Server instance, as in
LOCAL\SQLEXPRESS
. If you're configuring this in settings.php, it would beLOCAL\\SQLEXPRESS
- The "username" is a SQL Server "login" that you must create and map to a SQL Server user.
Changes since 7.x-1.0-rc3
- Sanitize comments after #1105848.
- #1170760: Only remove proper indexes when dropping the related objects.
- Restore the two-step PK creation. Breaks on Azure, but at least does not break on SQL Server.
- #1170760: Recreate the primary key.
- #1170760: Remove check constraints in dropFieldRelatedObjects().
- Implement additional tests for #1170760.