将php应用程序连接到MS SQL服务器

Question

TLDR: I'd like to connect a php application to a MS SQL server through an active directory account but haven't had much luck finding documentation on how to do that.

Most of the issues that people seem to have with this are pretty complicated I think I just don't have a strong enough grasp of the concept. When I try to connect it to the server, I get: Warning: mysql_connect(): No connection could be made because the target machine actively refused it.

The code I'm using is:

$user_name = "ADAccountName";
$pass_word = "ADAccountPW";
$datbase = "myDatabase";
$server = "#ipaddress#:#port#";

$db_handle = mysql_connect($server, $user_name, $pass_word);
$db_found = mysql_select_db($database, $db_handle);

I created a user "sa" through MS SQL Server Management Studio and attached it to an AD account (I don't seem to have access to create one without picking an AD account).

I've had luck connecting it to a database using MySQL Workbench (for testing) and a dedicated username/password, but the actual database I need to use is run by MS SQL Server Manager with an AD account. I've spent the greater part of the day going through forums and Microsoft's documentation on SQL Server Manager but I haven't found anything that can help me out with this.

I'm using php v. 5.2

Answer 1

If you're trying to connect to MSSQL you will need to do a few things to your web server first.

1.You will need to add PHP to your windows startup

2.Then you will need to install SQL Server Native client

3.Install the SQL Server drivers for your web server. SQLSRV30 is for PHP 5.4, SQLSRV31 is for PHP 5.5

4.Then go to your php.ini file and enable these extensions.

This will enable you to use PHP Data Objects.

You can connect to the DB like this:

try
{
    $conn = new PDO( "sqlsrv:server=$serverName ; Database=AdventureWorks", "sa", "");
    $conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
}
catch(Exception $e)
{ 
    die( print_r( $e->getMessage() ) ); 
}