Hi,
I have installed Moodle 2.5 on my Windows 2008 r2 box. PHP is 5.4.5. I have run some test php code and it does connect to the MS SQL database server that I have put the Moodle database on. The Moodle database is still empty. The SQL server is not local to the IIS server.
When I remove the config.php, I get the normal setup wizard. Below is my database config settings. What have I missed?
$CFG->dbtype = 'sqlsrv'; // 'pgsql', 'mysqli', 'mssql', 'sqlsrv' or 'oci'
$CFG->dblibrary = 'native'; // 'native' only at the moment
$CFG->dbhost = 'ip address'; // eg 'localhost' or 'db.isp.com' or IP
$CFG->dbname = 'moodle_staging'; // database name, eg moodle
$CFG->dbuser = '***'; // your database username
$CFG->dbpass = '*****'; // your database password
$CFG->prefix = 'mdl_'; // prefix to use for all table names
$CFG->dboptions = array(
'dbpersist' => true, // should persistent database connections be
// used? set to 'false' for the most stable
// setting, 'true' can improve performance
// sometimes
'dbsocket' => false, // should connection via UNIX socket be used?
ecustom path
// here set dbhost to 'localhost',
// (please note mysql is always using socket
// if dbhost is 'localhost' - if you need
// local port connection use '127.0.0.1')
'dbport' => '1433', // the TCP port number to use when connecting
// to the server. keep empty string for the
// default port
Any help would be most welcome.
Best wishes
Michael