Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Shipra Trivedi on June 22, 2017, 07:20:16 AM

Title: Not able to start UCS Application
Post by: Shipra Trivedi on June 22, 2017, 07:20:16 AM

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.

Title: Re: Not able to start UCS Application
Post by: Kubig on June 22, 2017, 09:05:38 AM

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.

Title: Re: Not able to start UCS Application
Post by: cavagnaro on June 22, 2017, 01:02:26 PM

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

Title: Re: Not able to start UCS Application
Post by: vjicecool on June 22, 2017, 08:05:23 PM

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

Title: Re: Not able to start UCS Application
Post by: cavagnaro on June 22, 2017, 08:44:17 PM

???  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

Title: Re: Not able to start UCS Application
Post by: vjicecool on June 22, 2017, 09:31:16 PM

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