Not able to start UCS Application

[Shipra Trivedi]

Hi,

I am not able to start the UCS application, it is throwing the below error :

The TCP/IP connection to the host INDHRGEN01, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:241)
at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2243)
at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:491)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1309)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:351)
at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:405)

Note: the port 1433 is unblocked from our end.Windows firewall is off.

Please advise.

[Kubig]

Is telnet working from the server? What the network sniff says? Is the DB connection configuration ok? The reason is pretty clear, UCS is not able to connect to the database and thus is not able to provide services.

[cavagnaro]

Enable TCP connection at your SQL server at Port 1433, that is more a SQL understanding rather than Genesys

Enviado de meu E6633 usando Tapatalk

[vjicecool]

I think on the UCS Dap you need to enable sql server listening port
server should be sql server for UCS dap

[cavagnaro]

  what? On DAP you configure how to connect, you don't enable anything. SQL Server need a fixed port for JDBC to work, so enabling the fixed port 1433 and not pipes will do the job at SQL Server

[vjicecool]

Sorry my bad, my wording was incorrect
when i say enable, i mean to say add port 1433 for sql