The International Splash Awards are back — happening at DrupalCon Vienna on 14 October 2025! Submit your project(s) by 16 June 2025 and join others from around the world to celebrate the very best of what Drupal can do.
By rshun on
I am new to drupal. How can I install Drupal to Ms SQL 2008?
Thanks,
R
Comments
The steps are:
. If you want to use friendly URL, install URLRewrite module in IIS to take advantage of the support of URLRewrite in Drupal 7 from here: http://www.iis.net/download/URLRewrite
. Install the PHP SQL Server Driver 2.0 from here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=80e44913-24b...
. Create a Drupal database and user login and password in SQL Server. (Please note the "instance" name which you will need when do the install)
. Download and uncompress Drupal 7 in your web space
. Download Drupal sqlsrv module from here: http://drupal.org/project/sqlsrv
. Uncompress and put in this folder: sites/all/modules/sqlsrv
. Copy the schema folder from sqlsrv/*.inc to this folder includes/databases.
. Install Drupal as you normally would but the database info as follow:
+ hostname: Please enter something like: 'YourSQLserverName\SQLInstanceName'. If you're configuring this in settings.php, it would be 'YourSQLserverName\SQLInstanceName'.
+ username: It is a SQL Server "login" that you must create and map to a SQL Server user.
That's it!
Here is an easier way if you are using Microsoft Web installer for Drupal which you can get from here: http://microsoft.com/web/drupal
To install Drupal on SQL
To install Drupal on SQL Server you need the SQL Server driver:
https://www.drupal.org/project/sqlsrv
The SQL Server PDO extension is only available for Windows (Linux support comming soon) so here is a deploying Drupal on Windows step by step guide:
http://www.drupalonwindows.com/en/blog/installing-drupal-windows-and-sql...
No matter what environment, deploying Drupal for performance and reliability is not a one click (or one command) task. Not if you want to understand what is going on and how to troubleshoot it when the house is on fire.
Note about David's guide above
In order for you to follow David's instructions on his site, which he links to above, you will be Not be able to complete the process in full unless you pay for his proprietary software "PhpMssql" which costs ¥16,044 (₹9,230)
All the best; intended.
-Chris (great-grandpa.com)
___
"The number one stated objective for Drupal is improving usability." ~Dries Buytaert *
Christopher, your comment is
Christopher, your comment is unfortunate and - above all - wrong. I advise you to thoroughly inform yourself before making rants or talking about others work/contributions.
You can perfectly complete a MS SQL Server setup without spending a single cent. There is a community supported branch that has no external dependencies (the 8.x-1.x branch) as you can see in the driver's page: https://www.drupal.org/project/sqlsrv
The 8.x-2.x is a version of the driver with commercial support.
Furthermore, the instructions you are mentioning clearly state that there is such an option. I edited the forementioned post so that this is more clear to people that are not willing to put the effort into properly reading things.
David: Thanks for replying. I am glad you did :o)
I know you put effort into helping improve Drupal, and the 'user experience' for developers who use Microsoft servers, and for that I thank you.
I was frustrated last year after I spent 3-days, happy and impressed, following the guide on your site, carefully documenting my every mouse-click by mouse-click, keyboard-key-press by keyboard-key-press steps, with the intent of posting a beginner's guide here at drupal.org-- only to be thwarted by what seemed to me to be the requirement for your paid version of "PhpMssql" if uses wanted to get your most up-to-date setup, and not some semi-abandoned little-supported 8.x-1.x version of sqlsrv.
I almost spent the 125 euros, but I am very glad I did not. On day-4 of my quest, I discovered that my online shared webhosting service provider, one of the most dominate on Earth (with the name "blue" in its name), and with whom I had just entered a 3-year contract, only uses Linux servers-- MS servers not being an option.
Admittedly, I have not, and do not intend to (at this time), spend the hours required to examine your site's guide to establish whether or not a full (and without exception) implementation of your process can be done without spending money-- or in other words, I do not know if your current corporate economic model has changed to the ideal of providing all the software for free, and letting your 'service providing' be your source of what has to be an unlimited income potential.
I would probably never even have bothered to post on this page were it not that I was compelled to do so as a response to a seemingly 'money grab' post by someone else, which I think you would agree is itself a completely inappropriate and misplaced rant here.
In conclusion, acknowledging that you have already stated that there is a community supported branch of sqlsrv 8.x-1.x, is it not true that what 'you' consider to be the best software solution for Microsoft users, and which is wonderfully delineated on your site, still requires sqlsrv 8.x-2.x, and money from users, instead of your releasing it from its proprietary bounds-- because you have not yet reached the confident realization that the 'service' department of your company, in and of itself, if properly managed, has a 'potencial de dinero ilimitado'.
All the best; intended.
-Chris (great-grandpa.com)
___
"The number one stated objective for Drupal is improving usability." ~Dries Buytaert *
Linux alternative
As of today, the above mentioned sqlsrv module only works on Windows installations, although Linux it's on the works.
However, if you are under Linux, you can use the https://www.drupal.org/project/dblib module, although it has no stable release and it is a far less maintained module (as the sqlsrv home page also states).
DB Configuration
About database configuration, only I can see the predefined MySQL, SQLite and PostgreSQL so, there should be a 4th option? or... I should use the predefined MySQL?
--
EDIT I finally resolved it so if is needed this comment could be erased.
That is because you did not
That is because you did not properly deploy both the driver and the pdo extension. Take a look at the tutorials.
BTW Linux support is already available!
Hi @david_garcia, I am just
Hi @david_garcia, I am just trying it on Azure but I finally found my mistake: on downloading and unzipping module, there is another sqlsrv folder into so I just put this second one into database folder and "quedó resuelto".
Thank you :)