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.
By meghavim on
Hi
I am new to drupal. I want to build site with following features. would you please guide me if i can use drupal or not?
-> platform windows and database sql server
-> assign user to group
-> grouping of users and and similar rules assignment for that group
-> different theme depends on user login from different group
-> show different block depends on user login from different group
-> administer of group can make block and assign it to different position and only users of that group can see it
-> administer of group can modify theme which assigned to his group
-> seo friendly url
I am programmer. I would love to create module for additional functionality. But I just want to make sure I can do all as per requirements.
Thanks in advance
Meg
Comments
I have run Drupal (5 and 6)
I have run Drupal (5 and 6) on Windows and IIS, but with MySQL, not SQL Server. Looks like there's a module for that though.
SEO friendly URLs may be difficult on Windows. Drupal and most open source PHP projects I am familiar with make use of Apache's mod_rewrite to create friendly URLs. This was something I was never able to accomplish on IIS. I saw some info on how to do it though google, but it involved custom error handlers; essentially treating each request for a friendly URL like an error, that I the override to display the correct page. It seemed too hacky for me. But maybe you are running Apache on Windows and I have not revisited this issue for a few years so things may have changed.
Some of the group based stuff you are looking for can be accomplished with Drupal's out of the box RBAC. But the part where you want a group administrator to be able to have some control over their group makes me think you might want something like Organic Groups. I have no experience with it, but it's a popular project.
- Brendan
_
Drupal on Windows / IIS / SQL SERVER has come a long way as of D7 and can be done no problem (including url rewriting). You can install it as a package using the Windows Platform Installer (just search 'drupal'), or manually by installing the individual components yourself. Google it -- there's tons of info.
And for that level of 'group' type control, you might want to checkout the http://drupal.org/project/og and related modules.
Drupal on Windows
I have to say that it works really great in a windows environment. Microsoft has come along way in growing around the php environment. Windows 2012 and SQL 2012 make it really easy to integrate any of the more popular php CMS apps (WordPress, Drupal, and Joomla).
_
totally agree-- I've just started moving my sites to IIS/SQL Server and it's going very well. It also has the added benefit of being able to leverage our SQL server team for optimzation and reporting/analysis with SSRS/SSIS.