RE: [PHP-WIN] Connect to MS SQL server on diff machine

Nicole, I've found on some instances that you need to specifically apply the user/group that IIS will be calling the PHP executable (and therefore php_mssql.dll) as, onto the 'PHP' directory. From what I've seen, the 'Everyone' group is not recognised by PHP. IE: If IIS is using anonymous access then you need to apply the 'IUSR_MACHINENAME' to the directory you installed PHP to with the minimum of Read/Execute. It may also be worthwhile applying this to the 'ntwdblib.dll' file as well. Also, check that your Default Network Library is set to TCP/IP and not Named Pipes. This can be found by running '%SYSTEMROOT%\System32\CliConfg.exe' Hope this fixes it up. Cheers -----Original Message----- From: Nicole Amashta [mailto:430ntr3k@bellsouth.net] Sent: Friday, 8 March 2002 2:34 AM To: php-windows@lists.php.net Subject: [PHP-WIN] Connect to MS SQL server on diff machine OK, I have Apache and PHP 4.0.6 installed. I want to be able to access an MS SQL Server, but I don't want to install SQL Server on the web server. What files are needed in order to do this? Normally, I have no problem with this because I typically have MS SQL Server installed on the web server. The only file I know of to put in the system32 root is ntwdblib.dll. But are there any others? (Aside from enabling the php_mssql.dll). I still get the unable to load php_mssql.dll even though the file exists and the extension_dir path is set to where I keep this extension. This works in all cases where I have the SQL Server running on the same machine as PHP/Apache, etc. So I am guess I am just missing some other files for this to work. ANyone encounter this scenario and realized how to resolve this? Any help or direction is appreciated! TIA, -- Nicole Amashta Web Applications Developer www.aeontrek.com -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php