Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

Integration of Google Cloud Sql Server with Google Apps Script

137 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