[Resolved] MSSQL Enterprise and PHP

chads2k2

I have read every tutorial and all manuals about MSSQL and PHP to get along. However, I have a problem. Has anyone used MSSQL Enterprise along with PHP? The reason for me asking is because our web server (IIS with PHP and ASP), and our SQL server are on different boxes. Yes I know I am spoiled. 🙂 I am developing an application based in PHP that has to use a different server. All the examples I have found seem to be based that the SQL server is directly on the box the webserver is on. That is all fine and dandy, but that doesn't fit my question.

So here is the question for all of you. What does the script look like to connect given the following information:

--- Bout the database
IP: 195.45.15.55
Name of server: NRSQLDL2
Version: SQL Server 2000
Mode: Non-mixed mode. Needs NT Authentication.
Database Name: ONINTRA
Table name example: TYPES
NT Name: MYDOMAIN\smithch
NT Password: PHP_STOMPS_ASP

--- Bout the webserver machine
IIS Version: 6.0 (Windows Server 2003)
- or -
Apache Version: 2.0.5 (Either one I can test on)
- both have -
PHP Version: 4.3.7 with all extensions enabled (and all work fine)

I am not the owner of the database but am setup in the permissions as an administrator with full access. Any other information you might need let me know. Also all names are fictious as well as IP's. I work in a rather large company structure that the webserver and the database server are on two different machines and no vital info can leave. I know you all understand that.

Thank you in advance, this board is great! Take care and have a good one,

Chad

bastien

when you define the host variable in the connection string for the mssql server, simply replace the 'localhost' with the server ip address...

chads2k2

Yeah well, no.

I had to finally break down and talk to the ASP developers about how they go about doing this. They had to add an account outside of the NT Athuentication and have it as a passthrough type account that will not have to be validated. Also went with an DSN-Less option too. The final code to do this looked like:

<?php
$db = mssql_connect ("<IP>,1433", "<WEB USERNAME>","<WEB USERNAME PASSWORD>") or die("Could not connect to Microsoft SQL Server 2000 at the moment");
mssql_select_db ("<DB NAME>", $db) or die ("Could not select db");

$sql = "SELECT * FROM <TABLENAME>";
$result = mssql_query ($sql, $db);
while ($row = mssql_fetch_array($result))
{
	$id = $row['<FIELD_NAME>'];
	echo "|| $id ||br>";
}
mssql_close($db);
?>

I had to protect the real info here but this is how you connect the two servers together. This is using Apache, with PHP 4.3.7 to test. Like I said the whole thing was making a user that is NOT on your domain to be your "pass-through" type account. Give them read/write or just read access and in the public users group. Keep in mind I am not a DBA I am a coder. So if you know more than I good for you. I know enough to really mess something up but not enough in MSSQL to make myself dangerous. MySQL is where I belong. haha.

Thanks anyway though Bastien!

Chad