Moodle in English: External database enrolment

After many days of pulling my hair out, trying every documented method to get the external enrollments working, I have to ask the community:

Has anyone actually managed to get Moodle (3.6) working - with MSSQL server for enrollments?

I have followed any online guidance I have been able to find, and I keep hitting the same errors:

"Starting course synchronisation...

Error while communicating with external enrolment database

Starting user enrolment synchronisation...

Error while communicating with external enrolment database"

Currently using latest freetds (1.1.4) and PHP 7.2.

I am now wondering if there is no longer a functional solution for this, so if anyone has this working I'd really like to hear from you.

Average of ratings: -

Re: External database enrolment

by Jon Witts - Tuesday, 7 May 2019, 4:40 AM

I have Moodle 3.6 working seamlessly with MSSQL for enrolment... However FreeTDS is no longer the supported method of connecting PHP to MSSQL...

https://docs.microsoft.com/en-us/sql/connect/php/microsoft-php-driver-for-sql-server?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/connect/php/installation-tutorial-linux-mac?view=sql-server-2017

The above are Microsoft's latest (SQL 2017) documentation for connecting Linux PHP installs to MSSQL server...

Good luck!

Average of ratings: -

Re: External database enrolment

by Andrew Soesman - Tuesday, 7 May 2019, 6:22 AM

Hey Jon,

Thanks for this mate – you’ve given me some more stuff to try.

From: "Jon Witts (via Moodle.org)" <noreply@moodle.org>
Reply-To: "posts+AAAAAAAAAAIAAAAAACeXFgAAAAAAF74iImbadk2xgeTIFosF@posts.moodle.org" <posts+AAAAAAAAAAIAAAAAACeXFgAAAAAAF74iImbadk2xgeTIFosF@posts.moodle.org>
Date: Tuesday, 7 May 2019 at 7:10 am
To: "Soesman, Andrew" <Andrew.Soesman@cg.catholic.edu.au>
Subject: Moodle in English: Re: External database enrolment