Hi, can anyone help me to resolve the error because while connecting to the new connection string of SQL Server Management Studio,i.e, jdbc:sqlserver://uaeadmmsql01mdg.c3ywakkpm0b8.us-east-1.rds.amazonaws.com:1433;databaseName=my_database_name it is showing an error which is "Connection failed". However, I have provided the correct username and password. What should be done in this scenario?
Discussion posts and replies are publicly visible
Did you check the tomcat-stdout log for any details?
This is what the log shows:
ERROR com.appiancorp.expr.server.scriptingfunctions.DataSourceFunctions - Failed datasource validation com.appiancorp.rdbms.datasource.DataSourceValidationException: java.sql.SQLException: Unable to obtain a connection within configured timeout
Caused by: java.sql.SQLException: Unable to obtain a connection within configured timeout at com.appiancorp.rdbms.datasource.ConnectionTimeoutBasicDataSource.getConnection(ConnectionTimeoutBasicDataSource.java:53) at com.appiancorp.rdbms.datasource.TeneoDataSourceValidator.validateDataSource(TeneoDataSourceValidator.java:61) ... 953 more Caused by: java.util.concurrent.TimeoutException at java.util.concurrent.FutureTask.get(FutureTask.java:205) at com.appiancorp.rdbms.datasource.ConnectionTimeoutBasicDataSource.getConnection(ConnectionTimeoutBasicDataSource.java:49) ... 954 moreCan it be due to the port number? Appian uses 1433 in this case , is that port blocked?