UCCX 7 SQL 2000 Server SA password

Unanswered Question
May 14th, 2009

Hi group,

I am having UCCX 7.0 in HA mode. I am using Cisco provided SQL 2000 Server. During the installation of SQL, it didn't ask me to specify the SA password anywhere.

Now, I've a requirement where I need to pull data from CCX databases but I don't have sa credentials.

Has anybody any clue what sa password could be? I've tried sa/sa, sa/password, sa/blank, sa/cisco, sa/Server_Administrator_Password, server_administrator/Server_Administrator_Password, cisco/cisco.

Thanks in advance,

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Kapil Atrish Thu, 05/14/2009 - 08:23

Since the SQL was installed by the Cisco provided media, it didn't ask for any authentication mode. I tried windows authentication and actually did get a user created but it still failed. I was guiding someone to do it over the phone and not sure if that guy did it correctly. I'll go and try these options myself once.

Thanks for your time,


clarkjaso Mon, 05/18/2009 - 08:03

The default UCCX 7 install sets the DB for Windows only authentication Mode. If you create a SQL user and give proper permission to DB and system rights, then change the authentication mode to SQL and Windows. It will work.

Tree is:

Enterprise manager -> SQL Server Group -> "Server" -> properties -> security tab

Kapil Atrish Mon, 05/25/2009 - 06:02

Actually the UCCX 7 generates random SQL SA password which is not documented anywhere, I confirmed this from TAC.

SQL is using Windows based authentication by default, I've created a local users on UCCX Servers. Now the remote system who wants to fetch the data uses those credentials to login and retrieve data from necessary tables.

TAC told me that mixed mode/SQL authentication is not supported on UCCX anymore, although I could see couple of Cisco docs mentioning the usage of mixed mode authentication. Finally, I had to agree with TAC and continued with windows authentication model.

Thanks for all the help,



This Discussion