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:
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. Previous Comments: ------------------------------------------------------------------------ [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
