Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

UCCX5.0 - external SQL database via ODBC issue

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,

3 REPLIES
New Member

Re: UCCX5.0 - external SQL database via ODBC issue

Hi,

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

New Member

Re: UCCX5.0 - external SQL database via ODBC issue

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,

New Member

Re: UCCX5.0 - external SQL database via ODBC issue

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.

344
Views
0
Helpful
3
Replies