MSSQL support ?

[NemoXP]

Hello.

Is there any way to enable mssql extension for php (with cpanel)?

W8ing for reply.
thanks

 

[cPanelTristan]

There is no way via cPanel itself to enable MSSQL, since this is not part of EasyApache. You can always follow the steps noted here to try to custom install the components necessary for MSSQL connections to function with cPanel servers:

http://forums.cpanel.net/f5/definitive-freetds-installation-instuctions-88561.html

Please note these other modules also needed:

http://forums.cpanel.net/f5/definitive-freetds-installation-instuctions-88561.html#post929002

 

[arun123]

Hi Guyz

I used the method mentioned in this post enable the mssql support. It gives all the necessary steps in enabling mssql support for php.
/http://linuxwebservertips.in/mssql_support_php/

 

[chrismfz]

unixODBC and FreeTDS installed properly.
Mssql also seems enabled in phpinfo().

Using tsql I can connect to a MSSQL server through the console.
But using php I can't.

An example:
php:

if (function_exists('mssql_connect')){
        echo 'OK<br />';
} else {
        echo 'NOT OK';

}
$connect = mssql_connect("xxx.xxx.xxx.xxx,1443", "user", "pass");
var_dump($connect);
$selected = mssql_select_db("db", $connect)
 or die("Couldn't open database");

And I get:

OK
bool(false) Couldn't open database

So, mssql commands seems to exist, I can connect normally through console using tsql, but not using php.
Any ideas?

 

[mtindor]

Unless you installed on alternate port, isn't MSSQL on 1433?

Mike

 

[chrismfz]

That was a typo sorry. It's 1433.

 

[mtindor]

If you're using a firewall such as CSF, you'll want to make sure that you add 1433 to the TCP_OUT exception list. Otherwise your server will not be able to connect outbound to the port.

Although, if you've connected to the same MSSQL server via the commandline of the cPanel server, firewall blocking likely is not the issue.

Mike