Re: SQL Server connection problem

Chris, Thank you for your response. Php.ini is exactly the same on both servers. I have only made three changes to the php.ini. -uncomment the mssql.dll extension -change the extension_dir -and set register_global to on. I do not use NT authentication. I am using domain name to connect to the database. One thing I missed to tell you is, I can connect the production server to our development database server, just not the production database server. The production servers have SSL Certificate (where the PHP is located) , but I am not sure if that is a problem. My next step is to install that on the development server to see if that gives a problem on the development server too. As far as, your suggestion to sniff the network, I am not sure how to do this. I will see, if someone here can help me with that. Any suggestion will help. Thank you again, Rachna Chris Hewitt <phpinst@manordata.uklinux.net> 07/28/2004 11:09 AM To RJahanzeb@computer.org cc PHP Install List <php-install@lists.php.net> Subject Re: [PHP-INSTALL] SQL Server connection problem On Wed, 2004-07-28 at 01:44, RJahanzeb@computer.org wrote: > I am trying to run PHP using iPlanet 6.0 which connects to the SQL > Server 2000. I have this working on my development server. On > production server I get the following error. > Warning: mssql_connect(): Unable to connect to server: (servername). > > Following is working already. > Connection from development server to the same database server with > same username and password. > Running PHP on the production server. > JSP sample to connect to the same database from the production server. > > I also ran the PHPInfo on both servers to see if anything was > obviously different. > > Please help, > Rachna I was thinking it was something to do with your production server itself until you mentioned a JSP sample from it connected OK. So we are looking for a difference between a JSP program and a PHP one. Clutching at straws now, so just a couple of ideas. Is there anything in your php.ini that is going to make a difference? There are many mssql settings, including whether NT Authentication should be used for making a connection. The error message you get is not very helpful. I think I would try to sniff the network to see the data from the production server to and from the database server to see if anything can be seen from that. For example, are your JSP and PHP programs calling the database server by IP address or domain name? If domain name is it being resolved? Not much but I hope it helps. Regards Chris