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 <[EMAIL PROTECTED]>
07/28/2004 11:09 AM
|
|
On Wed, 2004-07-28 at 01:44, [EMAIL PROTECTED] 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
