ID: 29434
User updated by: rjahanzeb at computer dot org
Reported By: rjahanzeb at computer dot org
-Status: Feedback
+Status: Open
Bug Type: MSSQL related
Operating System: win2k
PHP Version: 4.3.7
New Comment:
Yes, I installed the SSL on the development server and it seems that it
still works fine.
I do not have Client Network Utility installed on the production
server. I didn't think a need to do that since my development server
doesn't have it and it seems to be working fine. I tried to telnet to
the database on 1433 to make sure there is no problem there. Also, I
can connect to the database using JSP from the same webserver.
I know for sure my development server doesn't have SQL Client, is there
a dll something that gets install? I can look up to make sure if
development server has that.
Thank you for your help.
Previous Comments:
[2004-07-29 07:11:39] [EMAIL PROTECTED]
The SSL on the web server does not change anything with respect to the
communication between the two servers. That's between the web server
and the browser.
Can you connect from the production php server using Query Analizer?
This should be your first test. It sounds like a configuration problem.
You should use 'Client Network Utility' to specify host and server
configurations. If the server name you are using is unresolved it will
not be possible to do a connection.
[2004-07-28 22:09:54] rjahanzeb at computer dot org
I have two development servers one that runs PHP (and JSP) and one that
runs MSSQL Server.
I have two production servers, one that runs PHP (and JSP) and one that
runs MSSQL Server cluster.
The development PHP server can successfully connect to the development
MSSQL server with both PHP and JSP.
The production PHP server can successfully connect to the development
MSSQL server with both PHP and JSP.
The production PHP server can successfully connect to the production
MSSQL server using JSP but not PHP.
In all cases the database username, password and database connection
details are the same. The php.ini files are the same on the development
and production PHP servers.
Webserver on production server has SSL.
Error I get is Warning: mssql_connect(): Unable to connect to server:
(servername)
Note two things are different. One of the database server is a cluster
and one of the production server has SSL.
[2004-07-28 21:36:46] [EMAIL PROTECTED]
Please provide more information about your setup and the error/warning
messages you are getting.
The PHP extension uses the TDS protocol on port 1433 or netbios over
TCP/IP to communicate with the server.
[2004-07-28 21:06:42] rjahanzeb at computer dot org
Description:
I am unable to connect to SQL Server 2000 from the server which has SSL
Certificate installed via PHP. I can connect to the same database using
JSP from the same server.
I have made following changes to default php.ini
-uncomment the mssql.dll extension
-change the extension_dir
-and set register_global to on.
Is there an issue with PHP connecting to SQL Server over SSL?
--
Edit this bug report at http://bugs.php.net/?id=29434edit=1
