Having a lot of problems trying to install using MS-SQL and M1.7. After a bit of experimenting I now have PHP 5.2 and ODBTP installed and running. The Moodle install starts OK but I have two problems (at least...). I select the 'SQL*Server (UTF-8 enabled)' option which I assume is correct with ODBTP (?). Then I get the 'Checking your environment' page. This says Unicode "is recommended to be installed/enabled" with unicoderecommended at the foot of the page. I have read threads about this and would happily enable it if only I could find out where.
Ignoring this the install creates config.php and starts creating and populating tables. This looks promising until I get "Could not assign moodle/site:doanything to the admin role" and the process grinds to a halt.
Any help gratefully received
Jonathan
Windows server: Moodle 1.7 with MS SQL 2005 and IIS on Server 2003
by Jonathan Pennick -
Number of replies: 11
In reply to Jonathan Pennick
Re: Windows server: Moodle 1.7 with MS SQL 2005 and IIS on Server 2003
by tim harrison -
We used freetds rather than odbtp and followed the instal instructions on the this site. The major issue was checking that the mssql libraries were actually available using the php info page. We found that we had to play around a bit to get it to load due to incorrect access rights (the IUSR account was not given rights for some reason) rather than configuration issues. I just wondered if you had checked that odtbp was actually loading correctly.
In reply to tim harrison
Re: Windows server: Moodle 1.7 with MS SQL 2005 and IIS on Server 2003
by Chris Moffatt -
I have also gotten up and running with MSSQL using IIS on WinXP, PHP 5.1.4, and FreeTDS
In reply to Chris Moffatt
Re: Windows server: Moodle 1.7 with MS SQL 2005 and IIS on Server 2003
by Dan Marsden -
HI Chris,
be careful with 5.1.4 under IIS - check your event logs, you'll probably find some weird entries with w3c crashing..... - downgrade to 5.1.2 to prevent it from getting worse.
Dan
In reply to tim harrison
Re: Windows server: Moodle 1.7 with MS SQL 2005 and IIS on Server 2003
by Gerrard Shaw -
Tim, what access rights were set up incorrectly as I'm trying to set up Moodle 1.7 with MSSQL 2005 \ IIS6 \ Server 2003 but keep getting this error when trying to run http://localhost/install.php
You are not authorized to view this page
The URL you attempted to reach has an ISAPI or CGI application installed that verifies user credentials before proceeding. This application cannot verify your credentials.
HTTP Error 401.5 - Unauthorized: Authorization failed by an ISAPI/CGI application. Internet Information Services (IIS)
What do I need to change to allow the script to run? The test.php info page works fine btw...
Thanks in advance,
Gerrard Shaw
In reply to Jonathan Pennick
Re: Windows server: Moodle 1.7 with MS SQL 2005 and IIS on Server 2003
by Alan Jarvis -
I had a similar problem with IIS (but with MySQL not MS SQL) which might suggest the problem is with IIS not SQL (see my earlier post). I gave up and installed Apache instead. I assume you have read the instructions here? Interested to know how you get on as I will try again with IIS next week as I am unfamilar with Apache (but it does work...!)
In reply to Jonathan Pennick
Re: Windows server: Moodle 1.7 with MS SQL 2005 and IIS on Server 2003
by Dan Marsden -
HI Jonathon,
just be careful running PHP 5.2 with IIS - the last known good PHP version for IIS is 5.1.2 - see other posts on the forums regarding this.
thanks,
Dan
In reply to Dan Marsden
Re: Windows server: Moodle 1.7 with MS SQL 2005 and IIS on Server 2003
by Jonathan Pennick -
Thanks all; Still no joy. I have gone back to PHP 5.1.2 - ODBCTP claims to be installed OK. Clearly it connects and talks to SQL as I have tables created and some rows populated in mdl_log_display in fact it looks to be going fine until I hit "Could not assign moodle/site:doanything to the admin role". If I run it again I just get a repeated "A problem occurred inserting current version into databases". I've tried dropping the database and starting again - but clearly I am consistant in doing something wrong here. Looks to be to do with permissions but I have tried using the sa account without any luck.
Cheers
Jonathan
Cheers
Jonathan
In reply to Jonathan Pennick
Re: Windows server: Moodle 1.7 with MS SQL 2005 and IIS on Server 2003
by Jay Lee -
Did you follow the instructions here:
http://docs.moodle.org/en/Installing_MSSQL_for_PHP#Installation_overview
For creating the database in MSSQL? There's 2 options that need to be changed. You'll still get the warning about UTF-8 but it should install properly, assuming your using SQL 2005...
Jay
http://docs.moodle.org/en/Installing_MSSQL_for_PHP#Installation_overview
For creating the database in MSSQL? There's 2 options that need to be changed. You'll still get the warning about UTF-8 but it should install properly, assuming your using SQL 2005...
Jay
In reply to Jonathan Pennick
Re: Windows server: Moodle 1.7 with MS SQL 2005 and IIS on Server 2003
by R S -
I still dont see any documentations for migrating moodle 1.5 with mysql to Moodle 1.7 with MS SQL 2005 and IIS on Server 2003. Can anyone assist please?
I've made another post with a problem that no one has been able to reply to http://moodle.org/mod/forum/discuss.php?d=64746
Thanks.
Hi All,
I read all your post and downloaded FreeTDS 5_2 from http://kromann.info/php5_2-Release_TS/php5_2-Release_TS.zip. Before I used ODBC and my Moodle can connect to SQL Server 2000 succesfully. But now I would like to use FreeTDS, since ODBC is not actually recommended. My software configuration are XP SP2, SQL Server 2000, PHP 5.2.2, Moodle 1.8+ & FreeTDS but when I tried to install Moodle I couldn't connect to the SQL Server 2000. I've created a new database with name moodle and try to connect both using user sa and other user, but the database connection failed. This is the error message :
"Error: Database connection failed.
It is possible that the database is overloaded or otherwise not running properly.
The site administrator should also check that the database details have been correctly specified in config.php"
Then I tried to change the software configuration and now I'm using SQL Server 2005, PHP 5.2.1. But I still got the same error message. Is there anyone can help with this problem? Because I have no idea why since you all can install it but not me & I really got stuck here. Thank you very much for the help.
In reply to aswin a
Re: Windows server: Moodle 1.7 with MS SQL 2005 and IIS on Server 2003
by Allan McMillan -
Hi
I had very similar problems with my set up (sql 2005 and 2003 server) initialy i thought it was the connection that was giving me the problem but in actual fact it was the PHP configuration. On the website which guides you through the PHP install it does have some troubleshooting to try. I had to download dll files and all srts before i fianaly got my install running. Have a look at the PHP.ini file again, make sure your modules are not comented out.