UCCX5.0 - external SQL database via ODBC issue

Unanswered Question
Jun 12th, 2009

Hi,

Follows my scenario,

-external SQL server

-UCCX ODBC > systme DSN > add as name "db_external". TEST successful

-UCCX > subsystem > database > added the name as "db_external"

when I run "DB Read" in UCCX script, cannot detect the name "db_external" even I click the "Refresh Database Schema" button.

It works okay if I configure local data source (UCCX local box) with the above same process.

Any idean why I cannot detect the external SQL database from UCCX script "DB Read"?

Thanks in advance,

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
marina.kaminski Sat, 06/13/2009 - 20:16

Hi,

Can you ping db_external? Add an entry to the local hosts file if there is no DNS to resolve host names

cjrchoi11 Sun, 06/14/2009 - 06:08

No luck even add 'db_external' into local hosts

I never been experience external SQL databse integration so it may my basic configuration issue. pleaes advise based on the environment

-10.50.220.38=UCCX5.0 (workgroup,host name=ops1cucx)

-10.50.220.22=SQL 2000 (workgroup, host name=appl1)

-they can name based pinging each other

1. 10.50.220.22

-install SQL2000 and update the sa password to 'sa'

2. 10.50.220.38

-system DSN > create 'db_external' > select SQL authentication with sa/sa > successful

-UCCX > subsystem > database > db_external/sa/sa

-Script editor > DB read > click but not show the "db_external" in <-- at this time I captured the packet trace

3. packet trace in 10.50.220.22

source_ip,destination_ip,protocol,desctiption

10.50.220.38,10.50.220.22,SMB,Negotiate Protocol Request

10.50.220.22,10.50.220.38,SMB,Negotiate Protocol Response

10.50.220.38,10.50.220.22,SMB,Session Setup AndX Request, NTLMSSP_NEGOTIATE

10.50.220.22,10.50.220.38,SMB,Session Setup AndX Response, NTLMSSP_CHALLENGE, Error: STATUS_MORE_PROCESSING_REQUIRED

10.50.220.38,10.50.220.22,SMB,Session Setup AndX Request, NTLMSSP_AUTH, User: OPS1CUCX\CRSAdministrator

10.50.220.22,10.50.220.38,SMB,Session Setup AndX Response, Error: STATUS_LOGON_FAILURE

4. login failure in external SQL server while database schema refreshing in UCCX. Do I need extra steps to configure properly?

Advise please,

cjrchoi11 Mon, 06/15/2009 - 07:17

problem resoved by install SQL 2000 sp4 in external SQL server box. tcp port 1433 was not listing in SQL server box. also I changed the in to TCP/IP.

Actions

This Discussion