Integration of Google Cloud Sql Server with Google Apps Script

120 views
Skip to first unread message

Martentes Adm

unread,
Dec 2, 2019, 1:42:43 PM12/2/19
to Google Apps Script Community
I have problems to connect sql server on google cloud to google apps script, have tried many options do url connection like:
Jdbc.getConnection('jdbc:sqlserver://34.95.157.142:3306/revistamarcasserver', 'adm', '*****');

but is not connecting

Exception: Failed to establish a database connection. Check connection string.

Do you can help me to solve this problem to connect Sql Server to Google Apps Script?

Information about google cloud Sql Server:

DB Type: SQL Server 2017 Standard
Location: southamerica-east1-b

Using sql server management studio, I have tested and connected successfully, with this information

Efficient Small Business

unread,
Dec 5, 2019, 10:20:23 AM12/5/19
to Google Apps Script Community
Check out this video: https://youtu.be/VFE0Cbq581c

It walks you through how to connect Cloud SQL to Apps Script.

juan carvajal

unread,
Mar 5, 2023, 5:49:02 PM3/5/23
to Google Apps Script Community

var con_srt='jdbc:sqlserver://<server_public_IP>;databaseName=<dbNAme>;user=<user>;password=<pass>' (Connection String)
var con = Jdbc.getConnection(con_srt);
Reply all
Reply to author
Forward
0 new messages