Skip to main content
S
shalinid0001
August 30, 2022
Question

Database Connection Error

  • August 30, 2022
  • 2 replies
  • 0 views

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?

    2 replies

    stefanhelzle0001
    stefanhelzle0001
    August 30, 2022

    Did you check the tomcat-stdout log for any details?

    S
    shalinid0001Author
    August 30, 2022

    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?

    Terms & ConditionsAccessibility statement