[eluser]ZachFX[/eluser]
Hi,
I've been trying to connect to Microsoft Azure SQL but I'm not having any success.
Code:
$db['default']['hostname'] = 'tcp:serverName.database.windows.net';
$db['default']['username'] = 'username@serverName';
$db['default']['password'] = 'password';
$db['default']['database'] = 'dbName';
$db['default']['dbdriver'] = 'sqlsrv';
$db['default']['dbprefix'] = '';
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = TRUE;
$db['default']['cache_on'] = FALSE;
$db['default']['cachedir'] = '';
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
$db['default']['swap_pre'] = '';
$db['default']['autoinit'] = TRUE;
$db['default']['stricton'] = FALSE;
I'm getting a generic error, Unable to connect to your database server using the provided settings.
I have downloaded the PHP SQL Driver by Microsoft and added it into PHP Extension Dir and installed Microsoft SQL Server 2012 Express on my own computer.
Any help would be much appreciated.