JDBC Connections to MS SQL Server are failing now

[Matt Phillips]

Hi all,

In the past day all of our scripts that talk to our Microsoft SQL Server are now failing to connect.

This line used to work -

var conn = Jdbc.getConnection("jdbc:sqlserver://***.***.***.***;databaseName=***;user=***;password=***;");

But now it gets this error -

Failed to establish a database connection. Check connection string, username and password.

Is anyone else experiencing this?

Thanks,

Matt

[Chris Berlin]

Hi

It happen in my own script too.

I get the same issue when connect to db.

Someone already issued a ticket, but it doesn't fix now.

You may check this.

https://issuetracker.google.com/issues/187573928

Best regards

Chris

[Matt Phillips]

Hi All,

I searched in the Issue tracker and found lots of unhappy bug reports.

It sounds like it is affecting all JDBC connections (MySQL, SQL SERVER, hosted in and out of GCP).

For anyone else looking, here is a good Issue Tracker Search.

2 example issues are -

1. AppScripts get a "Failed to establish a database connection. Check connection string, username and password." [187573928]
   
2. JDBC MSSQL Can´t connect [192813431]
   

Thanks,

Matt

[Matt Phillips]

Thanks Chris, I just found that too.

It sounds like it is failing for everyone, so hopefully the fix comes quickly.

Cheers

Matt

[Administrativo Mi Casa]

Hi, 

this issue have a fix o not?

[Matt Phillips]

Yes, it was an outage on Google's end.  They resolved it

Here is one of the issues that was created to track it -

https://issuetracker.google.com/issues/187573928

Cheers
Matt