Database Connection Error

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

  • 0
    Certified Lead Developer

    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 more
    Can it be due to the port number? Appian uses 1433 in this case , is that port blocked?