What if I had installed SpamEnder which would have asked you for the same confirmation? We would never have received each others emails. Additionally people do not sign up for these forums to fill out these rediculous attempts to block spam. This should not be something I have to do to allow you to view my commments and advice on PHP. Charles -----Original Message----- From: Alan Hale [mailto:alan.hale@xxxxxxxxxxx] Sent: Wednesday, March 03, 2004 1:31 PM To: Charles P. Killmer Subject: Re: Windows 2003 and SQL Server issues (SpamEnder: BLOCKED Y2BB-SE24996-charlesk@xxxxxxxxxxxxxxxxxxxxx) In an effort to eliminate unsolicited e-mail, I have installed SpamEnder. Please REPLY to this e-mail, without modifying the subject line, so that I can receive your original message. Upon my approval, future e-mails you send to me will be released automatically. If you do not REPLY to this e-mail, SpamEnder will block all future e-mails from this address and will not give you another opportunity to reply. Copyright 2003, Evolvian, Inc. (http://www.evolvian.com/) ---------------------------------------------------------- Excerpt from original message: 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.601 / Virus Database: 382 - Release Date: 29/02/2004 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
