ID: 31596
Updated by: [EMAIL PROTECTED]
Reported By: php at thesheath dot com
-Status: Open
+Status: Bogus
Bug Type: MSSQL related
Operating System: win2003
PHP Version: 4.3.9
New Comment:
Please test the connection with mssql client tools first.
Connecting to mssql servers requires that the ports uses is open in the
firewall, that the correct user id and password is used (if the SQL
server allows SQL server authentication) or that the user account used
to execute the PHP script is authneticated on the web server. If
Integrated NT authentication is used you must specify
mssql.secure_connection = On in your php.ini file.
Previous Comments:
------------------------------------------------------------------------
[2005-01-18 12:33:00] php at thesheath dot com
Summary description changed
------------------------------------------------------------------------
[2005-01-18 12:17:10] php at thesheath dot com
Description:
------------
Webserver A is in an active directory VHOSTS, webserver B is in Active
directory VHOSTS2. MSSQL Server A is in VHOSTS and MSSQL Server B is
in VHOSTS2. If an attempt is made to connect to MSSQL Server A from
Webserver B using mssql_connect the connection fails. However, if an
attempt is made to connect to MSSQL Server B from Webserver B using
mssql_connect, the connection will succeed. This also applies if you
change the test around so webserver A connecting to MSSQL Server B.
This is purely an internal connection with the only difference in the
webservers and ms sql servers is being they're in different domains.
Reproduce code:
---------------
<?php
db_connect();
?>
<?php
function db_connect ()
{
$db = mssql_connect ("sql2k230", "*****", "******");
if (!$db) {
echo "\nError connecting to SQL Server, User = '" . "" . "', p/w =
'" . "" . "' \n\n";
die('Could not connect to server: ' . mssql_get_last_message());
}
$result = mssql_select_db ('master', $db);
if (!$result) {
die('Could not select database: ' . mssql_get_last_message());
}
}
?>
Expected result:
----------------
The script above should have html included, in which case whatever html
is included should be produced in the browser after the db connect has
taken place. Or a blank page if using the code only.
Actual result:
--------------
Warning: mssql_connect(): Unable to connect to server: sql2k227 in
e:\******** on line 28
Error connecting to SQL Server, User = '*****', p/w = '****' Could not
connect to server:
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=31596&edit=1
