Moodle with SQL Server

Execute the following commands

1)

CREATE LOGIN root WITH PASSWORD = 'Adm1n1234'
,DEFAULT_DATABASE = [moodle]
GO
-- Now add user to database

2)
USE moodle;
CREATE USER root FOR LOGIN root;
GO


3)

• ALTER DATABASE moodle SET ANSI_NULLS ON

• ALTER DATABASE moodle SET QUOTED_IDENTIFIER ON

• ALTER DATABASE moodle SET READ_COMMITTED_SNAPSHOT ON

4)

 Set the following settings in your php.ini file

• mssql.textlimit = 20971520
• mssql.textsize = 20971520