Drupal 7.x on IIS 8.5 and SQL Server 2012 R2

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
David Dubya's picture

Does anyone have experience configuring Drupal 7.x on IIS 8.5? We're moved the site from an older server (IIS 7.x).

Drupal site comes up, we can browse all content, but can't edit or add.

Admin user can open Admin Overlay pages, but cannot save any changes (save button just re-writes the overlay page). Edit content opens edit Overlay page, but has not content.

We're not getting any errors in either php or application logs.

Also, how do you handle the URL re-write, it does not seem to be available in IIS 8.5, we had to remove that "bit" from the site's web.config file.

Comments

URL Rewrite

David Dubya's picture

FYI, got above site working. We had to get our IT Department involved to load the Web Platform Installer and URL Rewrite v2. This was the cause of the inoperable Overly pages and content editing.

The directory sites/default/files is not writable

SofiaL's picture

I am configuring Drupal7, almost the same environment as yours. I am also installing the sqlsrv folder to connect to SQL Server, mainly because of all the old data I will need to use later.

At installing I can't pass the Verify Requirements tab. I get this error :
File system
The directory sites/default/files is not writable. An automated attempt to create this directory failed, possibly due to a permissions problem. To proceed with the installation, either create the directory and modify its permissions manually or ensure that the installer has the permissions to create it automatically. For more information, see INSTALL.txt or the online handbook.

I am very confused now, I have created the file folder (.../sites/default/files) and gave all user full control.

Do you have any suggestion for me?
Thanks,

When I did this, not only did

emijayne's picture

When I did this, not only did I have to give full rights to the "User" user, but I had to add the user "IIS_IUSRS" and give full access rights.

I hope this helps!

Everywhere, everyone FULLC CONTROL!

SofiaL's picture

This might be crazy, but I have tried all the combinations possible. Now I ended up giving full control to all the users and groups, not only to that file but also to all the wwwroot folder. It didn't solve my problem, still saying that files is not writable.

I don't know what else to try =(

Everywhere, everyone FULLC CONTROL!

SofiaL's picture

This might be crazy, but I have tried all the combinations possible. Now I ended up giving full control to all the users and groups, not only to that file but also to all the wwwroot folder. It didn't solve my problem, still saying that files is not writable.

I don't know what else to try =(

read only perhaps?

terri8502's picture

You don't have them marked as read only do you? Right click on the folder it says you can't write to and pick properties. On the general tab see if "read only" is checked. If it says it's not writeable that sounds like more of the issue, usually if you don't have permission is will say that. Good luck.

Administrator user

SofiaL's picture

Thanks for you help.
I was using my user, that is part of the administrator group but seems that I don't have all the rights.
As soon as I logged as Administrator user, I was able to complete the installation.

Thanks

Administrator user

SofiaL's picture

Thanks for you help.
I was using my user, that is part of the administrator group but seems that I don't have all the rights.
As soon as I logged as Administrator user, I was able to complete the installation.

Thanks

Create new user with rights to sites/default/files

lias's picture

What worked for me using IIS 8 on 2012 R2 was create a new user by going to Computer Management > Local Users and Groups > Users.

I went to the directory in inetpub and gave the user modify rights to the files directory.

SQL

fbaquero's picture

Hello, i want to instal drupal in my SQL Server it is
possible

Yes @fbaquero it is possible,

katannshaw's picture

Yes @fbaquero it is possible, but it's definitely not the easiest setup.

This is the best step-by-step tutorial: http://www.drupalonwindows.com/en/blog/installing-drupal-windows-and-sql...

IIS and Drupal 8

ricky93's picture

I experienced a very strange issue with Drupal 8 (no issues with other CMS programs, just 8). I am using IIS and My SQL for this setup. This error occurs with a new database, and a default settings, where the database has not even been implemented into the settings.php yet.

The following is what has occurred: At the database configuration page, I entered the database information, (select My SQL, database name, username, password, host, port number). Once the information is filled, I select "Save and Continue". Then, The page loads for a couple minutes; stating "waiting for localhost" at the bottom of the browser. Next, I am leaded to a page stating "Drupal already installed". So I delete the settings, and create a new database. I refilled the database information at the Database configuration page, and the error occurred again, stating "Drupal already installed". I redo the process until about the 5th try, Drupal installs displaying the loading bar.

Does anyone know the reason for this happening? Why does it say downloaded already, but then downloads after redoing a couple tries?

Thank you,

Below are links to the database with one after completely installed, and the other that installed partially (already installed issue).

https://i.stack.imgur.com/4mEwH.jpg

https://i.stack.imgur.com/3p49Y.jpg