CCC Reporter SQL Error

[SPIPOffice]

Hello

Has anybody had issues with SQL 2005 express working with CCC?

I've just installed, CCC works fine, but when I try and run reports I get DBNETLIB connectionopen SQL Server does not exist or access denied.

The SQL does exist, and the SQL and CCC was both installed as an Admin user.

Any ideas?

Thanks

 

[Bas1234]

Do the following;

SQL problems after an upgrade
Symptom - After an upgrade scenario with an SQL database and application of SQL
Service Pack 3, the following error may appear for all recorders (in this case
recdisplaynames):
ALARM - emergency: OA recdisplayname 1080=AgentInfo@qebi2450j: (5)
SQL call failed. 53, -1, 08001, [Microsoft][ODBC SQL Server
Driver][DBNETLIB]SQL Server does not exist or access denied. ** AND
** [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect()). MSSQL Database installation followed by SP3
application may change ODBC Data Source Attributes
This results from the application of SP3 to the MSSQL database modifying Data Source
attributes.
Solution - Do the following:
1. Update the Network Port for the OA ODBC Data Source.
If not known, determine Server Network Default Port. On the database server:
Troubleshooting the historical database
Issue 1.0 August 2003 107
a. Go to Programs > Microsoft SQL Server > Server Network Utility.
b. Choose the OA database instance.
c. Select TCP_IP.
d. Select Properties.
e. Note the port number.
2. Update the ODBC Data Source Network Port:
a. Go to Programs > Administrative Tools > Data Sources (ODBC).
b. Select the System DSN tab.
c. Double-click PA_DSN.
d. Press Next through the first window.
e. On the second window, select the Client Configuration button. In this window, click
Dynamically determine port twice. This will allow port entry. Enter the noted port
number.
f. Select OK.
g. Select Next (getting to this window verifies ODBC connectivity to the database).
h. Select Next.
i. Select Finish.


info found here;

http://support.avaya.com/elmodocs2/qq/pdf/docs/oa61/maint_trbl_color.pdf

Greetzzz...Bas

___________________________________________
It works! Now if only I could remember what I did...
___________________________________________

 

[SPIPOffice]

Hello

Thanks for the info.
We are using SQL Express 2005 and the option you have outline are not an option.

Regards