Help Failed to Connect After Switching from dblib to SQLSRV in P

[mroovster]

I’ve been using my ACP for a long time without any issues, but recently, it seems there was an update in cPanel that deprecated the use of the dblib driver for database connections.

 

The hosting provider informed me that dblib is no longer supported in PHP versions above 5.6, and they suggested switching to the sqlsrv driver.

 

Although my ACP is still running on PHP 5.6, I followed the advice and updated the database connection method in configs.php to use sqlsrv (by choosing the 4th option in the config), but I keep getting the following error: "Failed to connect! #SQLSRV #DB".

 

Has anyone come across this issue or know where I should start looking to resolve it?

 

Any insights would be really helpful!

[UnknownSoldier]

On 13/9/2024 at 12:42, mroovster said:

He estado usando mi ACP durante mucho tiempo sin ningún problema, pero recientemente, parece que hubo una actualización en cPanel que desaprobó el uso del controlador dblib para conexiones de base de datos.

 

El proveedor de alojamiento me informó que dblib ya no es compatible con versiones de PHP superiores a 5.6 y me sugirió cambiar al controlador sqlsrv.

 

Aunque mi ACP todavía se ejecuta en PHP 5.6, seguí el consejo y actualicé el método de conexión de la base de datos en configs.php para usar sqlsrv (eligiendo la cuarta opción en la configuración), pero sigo recibiendo el siguiente error: "Error al conectar! #SQLSRV #DB".

 

¿Alguien se ha encontrado con este problema o sabe dónde debería empezar a buscar para resolverlo?

 

¡Cualquier idea sería realmente útil!

 

Hello dear, if you are using a shared hosting, it is very likely that you do not have the sqlsrv connection module. you can check by adding a info.php

add an info.php file with the following code:

Quote

<?php
phpinfo();
?>

https://yourdomain.com/info.php

if your hosting provider allows php 5.6 and you have cloudlinux from php selector you can enable mssql.

If it does not allow that, you should ask the hosting provider if you can enable sqlsrv. (But many times they do not allow this method in shared hosting.)

 

[Nightw0lf]

also i have shared a tester.php here in mxc if you find it use it so you know what your hosting can do or not, for l2off servers i would recommend you l2jcenter its a br hosting and i recommend them for my clients when they get my donate panels for l2off because its reliable that will work, otherwise you should have knowledge how to install it your self in a unix operating system level.