What I ended up doing is creating a user on both the IIS box and the SQL box. Both low level users with the same username and password. I set IIS to use this new user account to run web requests. This was all it took. I think there is a better solution but I havent found it yet. Charles Killmer -----Original Message----- From: Kretschmer, Daniel [mailto:Daniel.Kretschmer@xxxxxxxxxxxxxxxxxxxxxx] Sent: Wednesday, April 28, 2004 9:04 AM To: Charles P. Killmer Subject: Windows 2003 and SQL Server issues Hello Charles, i have the same problem like you (see below) and i hope you have meanwhile a solution for this problem. If you have, is will be very friendly if you send me the solution. Thank, Daniel Kretschmer ************************************************************************ *************************************** 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 [EMAIL PROTECTED] Office: (320) 251-4700 ext 107 ************************************************************************ *************************************** -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
