+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 17
Virtual Learning Platforms Thread, Moodle & SQL Server 2005 in Technical; I was just wondering if anyone has managed to get moodle working using sql server 2005. I have php installed ...
  1. #1

    Join Date
    Dec 2007
    Posts
    140
    Thank Post
    12
    Thanked 2 Times in 2 Posts
    Rep Power
    14

    Moodle & SQL Server 2005

    I was just wondering if anyone has managed to get moodle working using sql server 2005. I have php installed and the site is configured correctly through IIS using the extensions. Using a php test page I am able to connect to our sql server 2005 instance and database.

    The trouble comes when you get to the moodle install.php page. It asks you to specify the following:

    Type
    Host Server
    Database
    User
    Password
    Tables prefix

    The confusing bit is the host server. Nearly every website tells you to put localhost there. My question is how does it know which instance to use to find the database?

    My settings are:

    Type: SQL*Server with UTF-8 support (mssql_n)
    Host Server: localhost
    Database: moodle
    User: moodle
    Password: <password>
    Tables prefix - mdl_

    As far as I can tell my settings should be correct but I get this error message:

    We could not connect to the database you specified. Please check your database settings.

    If anyone has any experience of this I would be most grateful if you could assist me. Cheers.

  2. #2

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    I presume you've read and followed the documentation?

    Installing MSSQL for PHP - MoodleDocs

    It sounds like you've not enabled TCP/IP in MSSQL as per step #2

  3. #3

    Join Date
    Dec 2007
    Posts
    140
    Thank Post
    12
    Thanked 2 Times in 2 Posts
    Rep Power
    14
    Hi,

    TCP/IP is enabled on the instance I'm using. It makes no difference. There is nothing blocking port 1433 so I don't understand what is going on.

    I noticed that there is boxes for TCP Dynamic Ports and TCP port these are blank but I did try putting 1433 in the TCP port and I got the same results.

  4. #4

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    Did you use the FreeTDS, ODBTP or the ODBC driver?

  5. #5

    Join Date
    Dec 2007
    Posts
    140
    Thank Post
    12
    Thanked 2 Times in 2 Posts
    Rep Power
    14
    I used the free TDS but there is a problem with it. If I enabled dblib.dll and uncomment mssql.dll it moans at me saying mssql.dll has to be enabled in php.ini. So I did that seeing as though free TDS won't work for me.

    What does TDS actually do anyway???? lol.

  6. #6

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    It's a database driver. Have you tried using ODBC?

  7. #7

    Join Date
    Dec 2007
    Posts
    140
    Thank Post
    12
    Thanked 2 Times in 2 Posts
    Rep Power
    14
    I haven't tried odbc but its not recommended. how do you have it setup?

  8. #8

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    I don't. I'm using LAMP.

  9. #9
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    176
    Thank Post
    43
    Thanked 61 Times in 49 Posts
    Rep Power
    26
    If you are using an instance of Sql Server rather than the default instance, then try servername\instancename for host server e.g. localhost\instance1. You could also try it with the machine name instead of localhost if that doesn't work.

    Richard
    SalamanderSoft Limited
    http://www.salamandersoft.co.uk
    Active Directory, SharePoint & Moodle provisioning

  10. #10

    Join Date
    Dec 2007
    Posts
    140
    Thank Post
    12
    Thanked 2 Times in 2 Posts
    Rep Power
    14
    No joy with that I'm afraid it still refuses to see the database. If I create an instance using SQL server 2000 it sees the database no problem however SQL server 2000 is version 8.0 and the latest version of moodle requires the database/instance to be version 9.0 which is sql server 2005. Although at the moment it looks like it doesn't work well with sql server 2005.

  11. #11
    rpwillis's Avatar
    Join Date
    Aug 2007
    Location
    SalamanderSoft Ltd
    Posts
    176
    Thank Post
    43
    Thanked 61 Times in 49 Posts
    Rep Power
    26
    Can you connect to the database using anything else such as management studio? Is the service for the instance running?

    Richard

  12. #12

    Join Date
    Dec 2007
    Posts
    140
    Thank Post
    12
    Thanked 2 Times in 2 Posts
    Rep Power
    14
    Hi,

    Yes I can connect using windows authentication or the dbowner account I setup. The service is running.

    I did setup a php page which connects to the database and that worked fine. It seems to be that moodle's install.php page will not see the database.

  13. #13
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    AFIK Sql Server 2005 runs on port 1427

    We have 2000 running on 1433 and 2005 on 1427

  14. #14

    Join Date
    Dec 2007
    Posts
    140
    Thank Post
    12
    Thanked 2 Times in 2 Posts
    Rep Power
    14
    Could you tell me what versions of moodle you guys are running and what sql server you are running it on?

    Thanks.

  15. #15
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    929
    Thank Post
    56
    Thanked 162 Times in 114 Posts
    Rep Power
    67
    Quote Originally Posted by ahunter View Post
    Could you tell me what versions of moodle you guys are running and what sql server you are running it on?

    Thanks.
    We are running 1.9 moodle but it's hosted on LAMP but we have integrated with SIMS.net Database which is running on SQL Server 2005 (ie pulls timetable course etc from sims.net)

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. SQL Server 2005 Backups Problem
    By ICTNUT in forum Windows
    Replies: 0
    Last Post: 7th July 2008, 09:53 AM
  2. SQL Server 2005 express & Win2k3
    By contink in forum Windows
    Replies: 8
    Last Post: 14th May 2008, 02:56 PM
  3. sims.net sql server 2005
    By itgeek in forum MIS Systems
    Replies: 2
    Last Post: 14th March 2008, 06:02 PM
  4. Not enough space for SQL server 2005 install
    By zag in forum MIS Systems
    Replies: 4
    Last Post: 10th October 2007, 08:02 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •