php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #31795 Permission issues with ntwdblib.dll and Windows 2003
Submitted: 2005-02-01 17:11 UTC Modified: 2005-03-20 18:08 UTC
Votes:8
Avg. Score:4.5 ± 0.7
Reproduced:6 of 8 (75.0%)
Same Version:3 (50.0%)
Same OS:6 (100.0%)
From: sa at ruraltel dot net Assigned:
Status: No Feedback Package: MSSQL related
PHP Version: 5.0.3 OS: Windows 2003
Private report: No CVE-ID: None
Have you experienced this issue?
Rate the importance of this bug to you:

 [2005-02-01 17:11 UTC] sa at ruraltel dot net
Description:
------------
This issue is pertains to Windows 2003 and ntwdblib.dll 7.00.839 which has been the packaged dll in the previous 3 releases.

Issue: Only an account on the MSSQL Server machine can have access to pass queries to the MSSQL i.e an account that has admin privileges on web server box (Windows 2003) and has privliges on the MSSQL box will allow the credentials to pass thus allowing the SQL login creditials to pass and the query to execute. 

While using Ethereal I noticed that the protocol used on Win 2k3 boxes accessing MSSQL was SMB and that it was performing NTLM authentication for the iusr_servname account against the MSSQL server. Where by the XP and 2000 box was using TDS with the same DLL. Once a changed the dll to the current version (ntwdblib.dll ver 8.00.194) running on the MSSQL box the apps worked normally on Win 2k3 boxes.



Reproduce code:
---------------
$test = mssql_connect('dbserver',"uname","pword");
if(!$test)
{
	$return = 'Test Failed: '.mssql_get_last_message()."\n";
}
else
{
	$return = 'Test succeeded';
}

Expected result:
----------------
Test Succeeded

Actual result:
--------------
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: 24.225.0.5 in D:\clients\admin.ruraltel.net\tmp\test_mssql.php on line 11


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-02-28 20:53 UTC] sniper@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php5-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5-win32-latest.zip


 [2005-03-20 18:08 UTC] sniper@php.net
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.


 [2005-12-04 00:34 UTC] shrockc at inhs dot org
I had the same problem when setting up PHP-4.4.1 on a Windows 2003 server that did not already have the ntwdblib.dll file in c:\windows\system32.  I replaced the included version of the .dll with the version of the .dll that I found in c:\windows\system32 of another windows 2003 server box that had Microsoft SQL Server 2000 installed.  I no longer have this issue.
 
PHP Copyright © 2001-2023 The PHP Group
All rights reserved.
Last updated: Wed Feb 01 04:03:45 2023 UTC