![use microsoft sql server management studio use microsoft sql server management studio](https://cloudblogs.microsoft.com/uploads/prod/2018/05/ssms-17.7-pic-1024x623.png)
Open "SQL Server Management Studio" and create a new empty database. Confirm the TCP/IP protocol is enabled in: SQL Server Configuration Manager -> Network Configuration -> Protocols -> TCP/IP enabled If the port was changed when MSSQL was installed, then specify the correct port number to open in the firewall. This is explicitly configured in the firewall installed (either Windows Firewall in the Control Panel or the configuration interface for other firewalls). Define the "sa" account password when requested (it's the default System Administrator account which has full access to all databases by default).īy default, MSSQL listens to port 1433 for incoming TCP/IP connections and this port needs to be opened in the firewall. Make sure to choose mixed authentication (Windows and local accounts) to keep things simpler later. ( A free version, SQL Server Express Edition is available for testing.)
USE MICROSOFT SQL SERVER MANAGEMENT STUDIO INSTALL
Install Microsoft SQL Server including SQL Server Management Studio. The steps detailed below must be performed before installing Moodle itself.įirst of all, the minimum required version of MSSQL has been stabilized to MSSQL 2005 (v.9).ġ. This short manual is for running Moodle 2.0 (and upwards) using the Microsoft SQL Server (MSSQL) RDBMS. Using the SQL Server Driver for PHP from Microsoft Introduction 1 Using the SQL Server Driver for PHP from Microsoft.