Connect to IPCC with JDBC

Unanswered Question
Feb 5th, 2008

We have IPCC-x 4.0.5(a). SQL authentication is Windows only (according to TAC this is the only mode supported).

We are trying to connect to the IPCC SQL db with a JDBC driver (jtds) and it is getting a connection failed message. The URL format we're using is: jdbc:jtds:sqlserver://XX.XX.XX.XX:1433;domain=ipcc;DatabaseName=CRSSQL;SelectMethod=cursor

The user id and password is being set when the connection is created. We get the error "Network error IOException: Connection refused: connect"

Anyone run into this or anyone have a solution?

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
stephan.steiner Tue, 02/05/2008 - 23:45

Quite frankly, don't listen to TAC in this case.. Call Manager and IPCC run fine with mixed authentication and nobody will ever be the wiser. We change any SQL DB where we need external access.

Also, why not use Microsoft's own jdbc driver?

Furthermore, are you sure the application that runs your code really runs under an account with the appropriate permissions?

cairns-a Wed, 02/06/2008 - 10:44

Thanks for the reply. Pardon my responses if they are not correct. I am just trying to relay from our web developers to this forum.

[from our developers]

It looks like port 1433 (the port that MSSQL generally listens on) is closed or otherwise not accessible on the IPCC boxes (I ran a port scanner on them from my PC). Does Cisco have IPCC running MSSQL on a non-standard port?

We also tried to using Microsoft's jdbc driver but it does not have Windows authentication build into it. Do you know of another jdbc driver that might?



cairns-a Fri, 02/08/2008 - 03:56

We figured this out. On IPCC-x 4.0.5(a) the default port used for SQL is 4433 not 1433. Not sure why Cisco has it set that way. Once we knew the port we were able to connect using the jdbc driver we have.

alanrstat Fri, 02/08/2008 - 05:38

Mixed authentication does not work on 5.0!!!

We found that out the hard way. We were unable to get Historical Reports with it in mixed mode. We use the mixed for a wallboard.

Cisco told us that Windows only was the only option.

To make both historical reports and the wallboard work we have to boot to mixed and change it to windows only without restarting the service.


This Discussion