cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1172
Views
0
Helpful
2
Replies

EDMT 10.5 Database connection FAILED.

Hello,

 

     I am running an upgrade from UCCE 9.0(3) to 11.6. 

     For migration HDS and Logger databases from version 9 to 11 with EDMT (via version 10.5) I tried to use advice from https://supportforums.cisco.com/t5/contact-center/ucce-v9-to-v11-upgrade/td-p/3014587

 

     I installed a temporary server with MS Windows 2008 R2 and MS SQL 2008 R2 and restored a backup for HDS and Logger databases from our current version 9.0. When I try to start migration with EDMT_1051 (using common upgrade migration type), I get an error: "Database connection to 10.XX.XX.113:1433 FAILED".

---

 Status:
▪ Checking the connection to the database mmk_sideB on 10.XX.XX.113:1433 ...
▪ Verifying the SQL Server collation ...
▪ SQL Server collation is not set properly for Cisco Unified ICM/CCE/CCH Found: Cyrillic_General_CI_AS
▪ Verifying the SQL Server version ...
▪ SQL Server version (SQL Server 2008 R2 10.50.4000.0) OK
▪ Verifying SQL Server Authentication Mode...
▪ SQL Server Authentication Mode is (Mixed) Mode OK
▪ Verifying Cisco Unified ICM/CCE/CCH Schema version ...
▪ Cisco Unified ICM/CCE/CCH Schema version (9,0) OK
▪ No Duplicate User Group Names Detected.

---

 

In MS SQL Profiler at the same time, I have following messages:

---

- network protocol: TCP/IP
set quoted_identifier on
set arithabort on
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed

SELECT @@MAX_PRECISION
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
SET IMPLICIT_TRANSACTIONS OFF
SET QUOTED_IDENTIFIER ON
SET TEXTSIZE 2147483647

EXECUTE sp_server_info 18

EXECUTE xp_msver 'ProductVersion'

EXEC master.sys.xp_loginconfig 'login mode'


-- network protocol: TCP/IP
set quoted_identifier on
set arithabort on
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed


SELECT @@MAX_PRECISION
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
SET IMPLICIT_TRANSACTIONS OFF
SET QUOTED_IDENTIFIER ON
SET TEXTSIZE 2147483647

SELECT Major FROM Version

select UPPER(UserGroupName) As 'UserGroupName' from User_Group group by UPPER(UserGroupName) having count(*) > 1

select UPPER(UserName) As 'UserName', UPPER(UserGroupName) As 'UserGroupName' from User_Group_Member group by UPPER(UserName), UPPER(UserGroupName) having count(*) > 1

---

 

What seems to be the problem? 

1 Accepted Solution

Accepted Solutions

The problem was with a collation. 

MS SQL Server collation was set to "Cyrillic_General_CI_AS" and it should be set to Cyrillic_General_BIN.

After reinstalling MS SQL Server with a proper collation, EDMT finished migration without any further errors.

View solution in original post

2 Replies 2

The problem was with a collation. 

MS SQL Server collation was set to "Cyrillic_General_CI_AS" and it should be set to Cyrillic_General_BIN.

After reinstalling MS SQL Server with a proper collation, EDMT finished migration without any further errors.

I like your style.

 

You asked a question and later posted a followup and then accepted your post as the correct answer and got some points.

 

BINARY sort order indeed. Carry on.

 

Regards,

Geoff

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers