Connecting moodle to a remote SQLServer database

Re: Connecting moodle to a remote SQLServer database

by Leon Stringer -
Number of replies: 0
Picture of Core developers Picture of Particularly helpful Moodlers

Have you configured SQL Server to allow TCP/IP connections? And is this listening on the 192.168.1.113 interface? This is configured in SQL Server Configuration Manager, e.g. (your settings may vary):

SQL Server Configuration Manager screenshot showing Network Configuration

You can also use Telnet on the VM to test the network connection (e.g. telnet 192.168.1.113 1433, you may need to install the Telnet client first: dnf install telnet). If you can't connect like this then Moodle won't be able to connect either.