RE: [PHP-WIN] Windows 2k3 sp2 and mssql error

Iswsue resolved. The issue was related to a security update to ISS. It stopped allowing a local anonymous account from accessing the mssql server. I created a new user account on the Domain, gave it little permissions in the domain (same as atypical user) and then it worked. I would not recommend this workaround for a production internet server but it does work in my environment where there is not any access from outside the firewalla nd there are not any more permissions than a standard user has anyways. Thanks for the suggestions. Z -----Original Message----- From: Zleviticus [mailto:zleviticus@fitnessnow.org] Sent: Monday, July 09, 2007 11:12 AM To: php-windows@lists.php.net Subject: [PHP-WIN] Windows 2k3 sp2 and mssql error I am perplexed with an issue that i need help on. I have searched and can not find a resolution and can not find out what is going on. Here is the situation: I have a windows 2003 Server running IIS 6, php 5.2.1 I have another windows 2003 server running mssql 2000 with all the latest service packs. i am using a php script via a web page to access data on the server and display it. when i run the page i get the standard: Warning: mssql_connect() [ <http://solomon/Flash/function.mssql-connect> function.mssql-connect]: Unable to connect to server: 192.168.1.9 I can connect to the sql server via the php script if i run it from my client in my editing software. What can i do at thins point to troubleshoot and get it to work. It was working prior to an installation of sp2 for win2k3 uninstalling sp2 is not an option.