how do i connect azure database with google spreadsheet script?

[Jap]

 created a user in the sql server manager studio with db_reader role , and i tried to connect with this code:

function AcessaVendas () {

  

   var URL  = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Connect").getRange('A1').getValue();

   var USER = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Connect").getRange('B1').getValue();

   var PASS = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Connect").getRange('C1').getValue(); 

/*

URL=jdbc:sqlserver://servername.database.windows.net:1433

   

USER= username that i createdin the ssms with db_reader

PASS= password

*/

   var conn = Jdbc.getConnection(URL, USER, PASS);

 

   var stmt = conn.createStatement();

   stmt.setMaxRows(10000);

   var start = new Date(); 

   var rs = stmt.executeQuery(myquery());

   var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Dados");

       ss.getRange('a2:h1000').clearContent();

   var cell = ss.getRange('a2');

   var row = 0;

   while (rs.next()) {

          for (var col = 0; col < 7; col++) {

            cell.offset(row, col).setValue(rs.getString(col + 1));

        }

        row++;

    }

    rs.close();

    stmt.close();

    conn.close();

    var end = new Date();

    Logger.log('Time elapsed: ' + (end.getTime() - start.getTime()));

}

but always apears this error:"Failed to establish a database connection. Check connection string, username and password."

i already tried onpening ip 0.0.0.0 to 255.255.255.255

someone could hep me?

[Sravani Yelamarthi (AdWords Scripts Team)]

Hello,

You can try the solutions suggested here and if the issue still persists, please reach out to Apps Scripts support as they are better equipped to deal with this.

Thanks,
Sravani Yelamarthi
AdWords Scripts Team