Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

ACS 5.2 remote database setting problem

Hello everyone,

I have installed ACS 5.2 appliance and try to backup report to remote database(MS SQL Server 2005) using remote database settings.

But the database is empty and the job in scheduler is failed.

So I check MonitoringAndReportingScheduler.log and found the log message in the attached file.

I try to find out answer in Cisco Support Community but found nothing.

But I google an article almost the same condiction as mine.

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_26931183.html

I wonder what database configuration should I alter to meet the requirement of this report backup.

Because there is nothing about database in ACS configuration guide.

Does anyone succefully using this function?

What does "

I have changed database collation from SQL Latin to no SQL and it's working." in the article mean?

Thanks in advanced.

Everyone's tags (4)
1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Re: ACS 5.2 remote database setting problem

Hi, Mason,

It's most probably because of the CSCtk83179 ACS 5 View export to remote SQL DB not working.

You have to wait for ACS 5.3 or patch 7 for ACS 5.2.

Cheers, Irina

---

PS: Please, rate helpful posts!

4 REPLIES
Cisco Employee

Re: ACS 5.2 remote database setting problem

Hi, Mason,

It's most probably because of the CSCtk83179 ACS 5 View export to remote SQL DB not working.

You have to wait for ACS 5.3 or patch 7 for ACS 5.2.

Cheers, Irina

---

PS: Please, rate helpful posts!

New Member

ACS 5.2 remote database setting problem

We tried yesterday with 5.3, doesn't look better ...

Cisco Employee

ACS 5.2 remote database setting problem

Hello, Rishi,

Well, it's hard to say what problem could you encounter without seeing logs ;-) If the error is exactly the same, I'd suggest to open a TAC case - as the bug, I've mentioned, is fixed in ACS 5.3.

Cheers, Irina

---

PS: Please, rate helpful posts!

New Member

ACS 5.2 remote database setting problem

We opened a case.

Here's the message in the scheduler :

ExportDataJob

Remote Database export Utility

System

Wed Nov 09 07:30:01 CET 2011

Export Data run Failed.

Failed

1389
Views
0
Helpful
4
Replies