Unable to Setup CCR 8, Problem in viewing Database

[itsupport5589]

Hi,

I wanted to setup CCR 8 and couldnt able to sucessfully implemented.

I have followed the CCR Setup Guide

http://downloads.avaya.com/css/P8/documents/100073303

Accordingly I tried to setup on Windows 2008 R2 64 Bit Server. Also Installed MS SQL Express Server 2012 on Same Server.

Now After Installing SQL Server Express, When im going to setup CCR 8, at the database selection, i cannot see Local\SQLEXPRESS Database to proceed further.

Please let me know how can i proceed and setup CCR 8 on Windows 2008 Server.

-Thanks,
Sam.

 

[morenot]

you can manualy write (localhost)/SQLEXPRESS

Saludos...

JLMT//

 

[hairlessupportmonkey]

actually try .\SQLEXPRESS

ACSS - SME
General Geek

 

[tlpeter]

I would stick as SQL 2010 and not 2012 as this is not supported.
Staying support is already a challenge with CCR

BAZINGA!

I'm not insane, my mother had me tested!

 

[itsupport5589]

Thanks All

Its should be finally [Local].

When I proceed further for installation, then when the website open automatically...it shouls Http 403- Forbidden.

I cannot see the website...

Looking for your valuable support !!

-Sam.

 

[DrDrayAvaya]

does

http://localhost

in IE come up with IIS start page?
how long after restarting everything are you trying to access the

http://localhost/ccrwebclient

page?
try accessing from another workstation on the LAN, security on browser on server may be stopping things from happening too.
one thing at a time I guess?

Cheers,

Chris

 

[itsupport5589]

Finally I have sucessfully Installed SQL 2005 and Started

http://localhost/ccrwebclient

Created Supervisor Accounts
Created Huntgroup in AVAYA & Added CCR Users
and login to see the Details
Now I can see the Users in Dashboard CCR Website

"When I go for Reporting and i See the Error
An unexpected error occurred which has been logged"

This is going to outbound calls centre. In that case im sure it shouldnt be voicemail pro required for routing incoming calls.

-Thanks,
Sam














Please report this error to your IPOCCR System Administrator.

 

[DrDrayAvaya]

I think it's SQLExpress with Advanced services that has reporting services built in, rather than standard SQLExpress 2005 standard?
bit rusty on that side of things, but we used the Advanced services edition and all's good.
there's a bit of a process to installing reporting side of things manually, sorry haven't been that brave yet. (or had the time) CCR Install says with advanced services too..

Cheers,

Chris

 

[itsupport5589]

Do you want me to upgrade to SQL Express to SQL EXP ADV??

 

[DrDrayAvaya]

sorry to quote from the RTFM

Installing MS-SQL

You must install MS-SQL before you install any of the IP Office Customer Call Reporter application components. During installation of the IP Office Customer Call Reporter application, the system requests access information for the database and tests the entered credentials in order to complete the IP Office Customer Call Reporter installation.

The MS-SQL can either be the free MS-SQL Express Edition or a licensed edition of MS-SQL. For details of the differences, see Database Requirements.

• If you are using MS-SQL Express Edition, install it on the same system as the main IP Office Customer Call Reporter application components.

• If you are using a licensed edition of MS-SQL, install it on the IP Office Customer Call Reporter server or on a separate system on the network. If you want to install the licensed edition of the MS-SQL on a separate system, then first install the IP Office Customer Call Reporter Database component on that system separately from the other IP Office Customer Call Reporter components. For more information, see Distributed Installation.



Installing Microsoft Express MS-SQL

If you are installing a licensed Microsoft SQL Edition, refer to the installation instruction that comes with the software.

Note: IP Office Customer Call Reporter requires the MS-SQL Server instance to support the Mixed Mode (Windows Authentication and SQL Server Authentication) access.

[highlight #FCE94F]1. Locate the software installation package that you have obtained (see Software Requirements). Express version (32 and 64 bits) are available in the Prerequisites folder of the IP Office Customer Call Reporter DVD.

2. Open the installation package to start installation.

[highlight #FCE94F]3. Click the required exe file:

• For 32-bit: SQLEXPRADV_x86_ENU.exe

• For 64-bit: SQLEXPRADV_x64_ENU.exe[/highlight]

Note: SQLEXPRADV_x86_ENU.exe and SQLEXPRADV_x64_ENU.exe are the versions with advanced services. If you do not install these versions of SQL Express Edition, the IP Office Customer Call Reporter Custom Report page will not display the link to launch Report Builder. You will have to install Report Builder manually.

The system displays the SQL Server dialog box. After a few seconds, the system replaces the dialog box with the SQL Server Installation Center window.[/highlight]

4. On the left side of the SQL Server Installation Center window, click Installation.

The system displays a list of installation options on the right.

5. On the right side of the screen, click New SQL server stand-alone installation.

The system displays the SQL Server 2008 dialog box requesting you to wait while the install program prepares for installation.

6. After a minute or so, the system displays the System Support Rules window.

7. If the installation fails any checks:

1. Click Show details or View detailed report to determine the cause of error.

2. Click Re-run to perform the checks again.

8. If the installation passes all the checks, click OK.

The system displays the window where you enter your license key and product edition.

Note: Depending on the edition you are installing, the license key may be present on the Product box.

9. If the Enter Product Key box is empty, enter the product key and click Next.

Select I accept the license terms.

10. Click Next.

The system displays the Setup Support Files window.

11. Click Install.

The Windows Installer prepares for the installation. After 30 seconds or so, the system starts installing the Windows Setup Support files. If the system does not encounter any problems, the system displays the message “Operation completed”.

12. Click Next.

The system displays the Feature Selection window.

13. Click Select All

14. Click Next.

The system displays the Instance configuration window.

15. Select the default instance setting.

16. Click Next.

The system displays the Disk Space Requirements window. This window provides the disk space information on the drive on which you are installing MS-SQL.

17. Click Next.

The system displays the Server Configuration window.

18. Set up the service accounts that you intend to use .to run the SQL server.

• If you have created Windows NT or Active Directory accounts for use with services, use the service accounts shown in the window.

• If you have not created Windows NT or Active Directory accounts, use the built-in Network Service account for all three services listed in the window.

19. Change the Startup type to Automatic for all three services. This automatically starts the SQL server database engine, SQL Agent and SQL Browser services when you re-boot the server.

20. Note: Setting up the service accounts allows the SQL server to start up automatically after installation.

21. Click Next.

The system displays the Database Engine Security window.

22. Change the Authentication Mode to Mixed Mode.

23. Enter a password for the system administration account.

The system displays the Database Engine Configuration window.

24. Click the Data Directories tab.

25. Select the directories to specify the drives in your system you are going to use.

The system displays the Error Usage Reporting window. The system asks if you want the system to send the error information to Windows or safely skip the information.

26. Select the check-boxes if you want Windows to send the error messages.

27. Click Next.

The system displays the Installation Rules window.

28. Click Next.

The system displays the Ready to Install window. This window summarizes what you are about to install and gives you a last chance to cancel or change any information.

29. To start the installation process, click Install.

The system displays the Installation Progress window.

30. After the installation is complete, the system displays the Complete window.

31. To verify that the installation has happened as expected, click the Installation Log link.

The system prompts you to re-boot to complete the SQL Server set-up.

32. Click OK.

The system brings you back to the SQL Server Installation Center window (see step 4).

33. Click Close.

34. Re-boot your system manually to complete installation.

 

[itsupport5589]

Yes ur right...


Now i tried to installed SQLEXPRADV_x64_ENU and its installed sucessfully..

Now still i cannot see the reports.

I guess i need to download the Report Builder for SQL 2005.....to view the AVAYA Report when i go to webccr reporting option.

Please let me know what to do.

IP Office Customer Call Reporter CCR Release 6.1.1.84 Software

Is it ok to download

http://support.avaya.com/downloads/...ntentId=C201011241614461980_9&productId=P0160

and try !!

-Thanks,
Sam.

 

[DrDrayAvaya]

should it not be CCR V8 that you're installing, not 6.1? I think you'd be better off making a fresh start on things perhaps, and make sure all the .net stuff is put on in correct order AFTER IIS installed etc, follow through the installation manual to the tee.
I do remember having that same fault once upon a time, and pretty sure it's to do with IIS not displaying, can't remember the actual details though.. it was a late night!!

2008 server needs framework 3.5 and 4 still I think, there's not much in the installation guide for 2008, but it has a fair bit of that pre req stuff already sorted on the .net side, but IIS has to be there first still.

Seriously, probably quicker to just make a clean start. sorry...

Cheers,

Chris

 

[tlpeter]

Why are you first using SQL 2012 and now you talk about SQL2005?
8.0 only support SQL 2008 so install that one and try again.


BAZINGA!

I'm not insane, my mother had me tested!

 

[itsupport5589]

Yeah..I done the fresh instaltion

Removed IIS 7
Removed SQL 2005 Express Advance 64 Bit
Removed CCR
Removed .Net 4.5
Removed Crystal Report 2008
Removed Visual Studio
Removed VC++

Installed IIS 7 + Enabled ASP.Net
Removed SQL 2005 Express Advance 64 Bit
Removed CCR
Removed .Net 4.5
Removed Crystal Report 2008
Removed Visual Studio
Removed VC++


Still cannot see the website.

Is there any one who can assist me to setup....through Teamviewer.

-Thanks,
Sam.

 

[itsupport5589]

Now I tried from Windows 7 OS..

When I go with 2005...i cannot see Reporting.

When I go to 2008....there is an option for reporting..

Now I have freshly install all..and its started showing me..the ccr webclient site.

I tried to add AVAYA IP Office and main page....but it still shows disconnected. I disabled the firewall and disabled av....but couldnt get connected.

Is there any option.

-Thanks,
Sam.

 

[hairlessupportmonkey]

You also said this is an outbound call centre. Sorry, but get your money back, CCR isnt any good for outbound call centres.

ACSS - SME
General Geek

 

[itsupport5589]

Dear......Thanks for your valuable response..

I just needed to setup CCR for our Cal Centre Agents.
Whether its incoming or outgoing that they will look after..

I need to get connected through CCR to IP Office and get details for hunt group...which was assign CCR Users in IP Office..then let the superivisor account handle everything rest accordingly..

Reporting is the main concern.

-Thanks,
Sam.

 

[DrDrayAvaya]

hmmmm... Sam, you might be struggling with Win7 OS... do you have the installation PDF handy just to step thru, ticking each bit off. it just wont behave if things aren't done in right order... like installing IIS before .net updates etc, registering the .net stuff properly with IIS is sounding like a big part of the problem you're having. Do you have the DVD with all the pre req .net stuff bundled from Avaya? it's easy enough to download from microsoft download site in any case.

here's the install pdf...

https://www.dropbox.com/s/ycgr8ah3v03j8jw/ccr_installation_en.pdf

and server specs
2.3 Server ComputerThis section details the minimum requirements for IP Office Customer Call Reporter server computers.·
Windows Operating System The IP Office Customer Call Reporter services are supported on the following operating systems.
Only 32-bitversions are supported unless stated otherwise. · Microsoft Windows Server 2003 SP2. · Microsoft Windows Server 2003 R2. · Microsoft Windows Small Business Server 2003 R2. · Microsoft Windows Server 2008 SP2 (32-bit and 64-bit)

· IIS Web Server IP Office Customer Call Reporter uses the IIS web server component of the operating system: · IIS V6 or higher.

· It is important that IIS is installed and running before any .NET software packages are installed as these willinstall additional components if they detect IIS on the server. If .NET is already installed before IIS wasenabled, then .NET should be reinstalled.

· The ASP.net option for the IIS server must be set as Allowed. · IP Office Customer Call Reporter only supports installation onto an IIS server running its default web site onport 80 (the default port). · IP Office Customer Call Reporter uses web.config files that are installed in its own virtual directories under theIIS default web server root.
If another applications erroneously installs a web.config file in the IIS default website's root directory, that web.config will affect all other applications using the IIS including IP Office Customer Call Reporter.

· Hardware Requirements The following are the minimum requirements for the computer hosting any components of the IP Office CustomerCall Reporter server application.
· Processor: Intel Pentium D945 Dual Core or AMD Athlon 64 4000+. · RAM: 2GB (4GB for optimum operation). · Free Hard Disk Space: 30GB. · Additional: CD or DVD drive for software installation. · If installing a licensed edition of MS-SQL on the IP Office Customer Call Reporter server computer, the separaterequirements of the MS-SQL Edition must be meet.

Notes1.The installer of the IP Office Customer Call Reporter Server platform must have Windows administrative rights toproceed with the installation. If the correct rights are not available a message appears informing the installer and
the installation will be stopped. 2.The customer map functions require Internet access from both the server computer and the client computer.

 

[hairlessupportmonkey]

The Min requirements in Avaya's docs for CCR are about as useful as a chocolate fire-guard. they are woefully under specified even for a small call centre.

You need decent entry level server like a dell R310 with SAS drives, decent CPU and min 8GB RAM, (even for a smallish site) otherwise in 6mths, its going to run like rubbish. trust me. It needs to run Windows Server 2Kx and a full version of SQL 2005/8 is highly recommended due to the size constraints with express versions.

ACSS - SME
General Geek

 

[itsupport5589]

Yes I already tried..running.....on Win 2008 64 .....with 8 GB Ram and good HDD Space.

IN 2008 SQL Express....after installation....i tried to load IP CCR 8 and the at the time of selection database...i cannot see the dataavailable.....to select....

When I load 2005....i can see the database selection while insatllation CCR 8....but in which its giving reporting error.

Now, i freshly installed 2008 on Win 7 and Instaled CCR 7....now im able to see the website of ccr web client...but however the Website was showing disconnected when i tried to insert ip of avaya ip office........


can you please help me out to resolve the problem over teamviewer plz.

-Thanks,
Sam.