IssueTracker

Before filing an issue, please read and follow these instructions carefully.

First, please search through existing issues to ensure that the bug has not already been reported. You can start the search here: https://issuetracker.google.com/savedsearches/566234

If the issue has already been reported, you can click the star next to the issue number to subscribe and receive updates. We prioritize responding to the issues with the most stars. You can also comment on the issue to provide any details of your experience with it.

If your issue has not been reported, please provide all of the following:

A short description of the issue:

We are not able to connect to a MS SQL server database using the JDBC driver (using either of Rhino or V8 runtime). Everything had been working fine till day before yesterday evening. The connection could be established at certain times yesterday and today also, but most of the time the connection cannot be established.

A small code sample that reliably reproduces the issue. The sample should run as-is or with minimal setup, without external dependencies.

function getDatabaseConnection(){
	try{        
		var address = gl_AppDBConnection.address;
		var user = gl_AppDBConnection.user;
		var userPwd = gl_AppDBConnection.userPwd;
		var db = gl_AppDBConnection.db;
		var msSqlUrlSyntax ='jdbc:sqlserver://'
		var dbUrl = msSqlUrlSyntax + address + ';databaseName=' + db;
		var conn = Jdbc.getConnection(dbUrl, user, userPwd);        
		return conn;	
	}catch(e){
               console.info("STACK: " + e.stack);
               console.info('ERROR: ' + e.message);
	       throw "Could not connect to database. Please try after some time. Error: " + e.message;
	}
}

What steps will reproduce the problem?

1. Running the above code with the correct database connection parameters will reproduce the issue.

What is the expected output? What do you see instead? If you see error messages, please provide them.

The connection object in the above code is 'undefined' and we are getting the following error: Error: Failed to establish a database connection. Check connection string, username and password.

Please provide any additional information below.

We are able to connect to the same database from other (non-Google Apps Script) applications using the same connection parameters.

Everything was working fine till day before yesterday evening

No changes to code have been made in recent times which could have introduced a bug at our end.

We are able to connect to another MS SQL server database using the exact same Google Apps Script code given above.

There is no firewall at our end blocking the connection .