#29434 [Opn->Csd]: Unable to connect to SQL server2000
ID: 29434 User updated by: rjahanzeb at computer dot org Reported By: rjahanzeb at computer dot org -Status: Open +Status: Closed Bug Type: MSSQL related Operating System: win2k PHP Version: 4.3.7 New Comment: You can close this issue. I ran cliconfg.exe and I found out that there was no default network library set. I set up the default to TCP/IP and added the SQL Server's name with port. It worked after that. I am not sure how my development server doesn't have this configuration and it still works. Also, I am not sure how this exe file got on the production server since I never installed the SQL Client. But thank you for your help. Previous Comments: [2004-07-29 17:07:13] rjahanzeb at computer dot org 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. [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=29434&edit=1
#29434 [Fbk->Opn]: Unable to connect to SQL server2000
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=29434&edit=1
#29434 [Fbk->Opn]: Unable to connect to SQL server2000
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
#29434 [NEW]: Unable to connect to SQL server2000
From: rjahanzeb at computer dot org Operating system: win2k PHP version: 4.3.7 PHP Bug Type: MSSQL related Bug description: Unable to connect to SQL server2000 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 bug report at http://bugs.php.net/?id=29434&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=29434&r=trysnapshot4 Try a CVS snapshot (php5): http://bugs.php.net/fix.php?id=29434&r=trysnapshot5 Fixed in CVS: http://bugs.php.net/fix.php?id=29434&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=29434&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=29434&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=29434&r=needscript Try newer version: http://bugs.php.net/fix.php?id=29434&r=oldversion Not developer issue:http://bugs.php.net/fix.php?id=29434&r=support Expected behavior: http://bugs.php.net/fix.php?id=29434&r=notwrong Not enough info:http://bugs.php.net/fix.php?id=29434&r=notenoughinfo Submitted twice:http://bugs.php.net/fix.php?id=29434&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=29434&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=29434&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=29434&r=dst IIS Stability: http://bugs.php.net/fix.php?id=29434&r=isapi Install GNU Sed:http://bugs.php.net/fix.php?id=29434&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=29434&r=float