<HTML>
<HEAD>
<TITLE>Connecting to UCCX Database via SQL</TITLE>
</HEAD>
<BODY>
<FONT FACE="Calibri, Verdana, Helvetica, Arial"><SPAN STYLE='font-size:11pt'>All,<BR>
<BR>
Under IPCC Express 3.x we utilized the famous callsinqueue.asp application to push our call center and helpdesk stats to our phones. Recently we upgraded to UCCX 7.x we are running into some issues connecting from our web server to the CRS database via ODBC. <BR>
<BR>
Under 3.x, we had created a user “stats” using Enterprise Manager which had db_public and db_readonly to the CRS database. After reading the documentation it seems that the CiscoWbUsr or wallboardUser ID has been created with the same access as our previously created “stats” ID. However, I can not successfully create a ODBC connection using either of the ID’s. Per TAC suggestion, I changed the password to the CiscoWbUsr yet it still didn’t work. Note that I also changed the server into mixed authentication mode so that I could get around the “trusted connections” SQL requests. Enterprise Manager is not installed on the server and I can’t seem to browse the server from our old CCM 4.1(x) servers using Enterprise Manager there.<BR>
<BR>
Does anyone have a fix to this? TAC is investigating but I thought I would throw this out here to see if anyone else has had any luck (that tried).<BR>
<BR>
Matt</SPAN></FONT>
<P><FONT face=Arial color=#808080 size=1>
<HR>
</FONT></P>
<P><FONT color=#808080><FONT face=Arial size=1>CONFIDENTIALITY STATEMENT<BR>This
communication and any attachments are CONFIDENTIAL and may be protected by one
or more legal privileges. It is intended solely for the use of the addressee
identified above. If you are not the intended recipient, any use, disclosure,
copying or distribution of this communication is UNAUTHORIZED. Neither this
information block, the typed name of the sender, nor anything else in this
message is intended to constitute an electronic signature unless a specific
statement to the contrary is included in this message. If you have received this
communication in error, please immediately contact me and delete this
communication from your computer. Thank you.</FONT> </FONT></P>
<P><FONT color=#808080>
<HR>
</FONT></P>
</BODY>
</HTML>