I had Google Apps Script directly connected to my server that has SQLserver through JDBC to synchronize Google Sheets data (read rows, insert/update SQL records) for free, but since Thursday, March 12, 2026 I am receiving this error: ❌ The connection failed. Error: Failed to establish a database connection. Check connection string, username and password. The user name and password work correctly with SQL Server. THE CODE USED IS
function PRUEBA_FINAL() {
// URL limpia y exacta que requiere Google
var dbUrl = "jdbc:sqlserver://###.##.###.###:#####;databaseName=NOMBRE";
// var dbUrl = "jdbc:sqlserver://###.##.###.###:#####;databaseName=NOMBRE" + ";encrypt=false;trustServerCertificate=false;";
var user = "##";
var userPwd = "################";
console.log("Cruzando los dedos... Intentando conectar con TLS 1.2 activado.");
try {
var conexion = Jdbc.getConnection(dbUrl, user, userPwd);
console.log("¡ÉXITO TOTAL! 🎉 Logramos entrar a la base de datos.");
// Cerramos la conexión
conexion.close();
} catch (error) {
console.log("❌ Falló la conexión. Error: " + error.message);
}
} que podría hacer, he tambien intentado enviarle el comando encrypt=false ni trustServerCertificate=true (nos tira error de URL Malformed)