Resolution:
Title
Exception when starting the Administrator with MS SQL server or while creating a domain using the domainutility, " com.tibco.runtime.pool.ServerNotAvailableException: Server not available at address jdbc:sqlserver://<server_name>:<port>;databaseName=<database@instance> ".
Symptoms
=======
com.tibco.runtime.pool.ServerNotAvailableException: Server not available at address jdbc:sqlserver://ax-sqlsrv-01.axereal.dom:1433;databaseName=EMS-DEV@TIBCO_ADM
at com.tibco.runtime.pool.impl.ConnectionPoolImpl.getAvailableObject(ConnectionPoolImpl.java:198)
at com.tibco.runtime.pool.impl.ObjectPoolImpl.getObject(ObjectPoolImpl.java:219)
at com.tibco.runtime.pool.impl.ConnectionPoolImpl.getObject(ConnectionPoolImpl.java:188)
at com.tibco.runtime.pool.impl.ConnectionPoolImpl.getConnection(ConnectionPoolImpl.java:219)
at com.tibco.runtime.pool.impl.ConnectionPoolImpl.getConnectionWithRetry(ConnectionPoolImpl.java:380)
at com.tibco.pof.entitystore.db.DBEntityStore.init(DBEntityStore.java:456)
at com.tibco.pof.entitystore.EntityStoreManager.a(EntityStoreManager.java:221)
.
Caused by: com.tibco.runtime.pool.ServerNotAvailableException: Server not available at address jdbc:sqlserver://ax-sqlsrv-01.axereal.dom:1433;databaseName=EMS-DEV@TIBCO_ADM
Resolution
=======
Add the following property to the Administrator tra and hawkagent .tra file if the error occurred while starting up the domain.
java.property.TIBCO_SECURITY_VENDOR=j2se
If the error occurred during the domain creation then add this property into the domainutility.tra or domainutilitycmd.tra file.