Also are you using windows or mixed mode authentication? On the sql box do you see any audit failures in the event logs indicating a failed login attempt? -----Original Message----- From: Svensson, B.A.T. (HKG) [mailto:B.A.T.Svensson@xxxxxxx] Sent: Wednesday, March 03, 2004 3:17 AM To: 'php-windows@xxxxxxxxxxxxx ' Subject: RE: Windows 2003 and SQL Server issues Is the web server located at the same machine as MS SQL server? Does it work with isql.exe (command line version) to connect to MS SQL server? -----Original Message----- From: Charles P. Killmer To: php-windows@xxxxxxxxxxxxx Sent: 2004-03-03 02:19 Subject: Windows 2003 and SQL Server issues I am having trouble configuring PHP 4.3.4 on Windows Server 2003 to connect to SQL Server 2000 on a Windows 2003 Server across the LAN. Now PHP is configured correctly because when I run the script from the command line, ie c:\php\php.exe c:\site\file.php, I get the results from the query. Its a simple select count(*) from table query. When I request the same file through a browser I get the error "PHP Warning: mssql_connect(): Unable to connect to server: ServerName" If I change the script to just echo phpinfo(); I get everything I would expect. Extensions are in the right spot, mssql.dll is loaded... This tells me that IIS 6.0 is configured to run the php.exe. The command line test tells me that php is configured to connect to the database. It seems to be that only when IIS tries to run the code to connect to the database that I run into issues. Possibly an issue of Windows 2003 being too secure in some area to allow the webuser to connect to the database server. I have tried changing from the predefined "Network Has anyone run into issues with something like this? Thank you for any help on this. Charles Killmer Netgain Technology CharlesK@xxxxxxxxxxxxxxxxxxxxx Office: (320) 251-4700 ext 107 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
