Joomla! 3 on IIS 7 with SQL Server 2012 - Joomla! Forum - community, help and support

i'm new joomla!. responsive design , ability use sql server might make joomla! interesting alternative new project.

i'm stuck on second page of joomla web installer. i've created empty database on sql server 2012 (not express) , gave myuser db_owner membership. on database configuration page entered:

database type: microsoft sql server
host name: n53 (i tried n53/sql server , variety of other combinations)
username: myuser
password: mypassword
database name: mer-ws

but get:
could not connect database. connector returned number: database sqlsrv_connect failed

when run script joomla directory:

code: select all

<?php
$servername = "n53";
$connectioninfo = array("uid"=>"myuser", "pwd"=>"mypassword", "database"=>"mer-ws");
$conn = sqlsrv_connect( $servername, $connectioninfo);
if( $conn === false )
{
     echo "could not connect.<br>";
     die( print_r( sqlsrv_errors(), true));
}
if( $client_info = sqlsrv_client_info( $conn))
{
       foreach( $client_info $key => $value)
      {
              echo $key.": ".$value."<br>";
      }
}
else
{
       echo "client info error.\n";
}
sqlsrv_close( $conn);
?>

i get:
driverdllname: sqlncli11.dll
driverodbcver: 03.80
driverver: 11.00.2100
extensionver: 3.0.3421.0

so, can connect sql server database using php , iis seems working.
any idea i'm missing? thank you!

did resolved?

are database on same server web? use "localhost" server name.
try use full domain name server n53.somedomain.com