ID: 29434 Updated by: [EMAIL PROTECTED] Reported By: rjahanzeb at computer dot org -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: win2k PHP Version: 4.3.7 New Comment:
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. Previous Comments: ------------------------------------------------------------------------ [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=29434&edit=1