topic ACS 5.2 remote database setting problem in Network Access Control https://community.cisco.com/t5/network-access-control/acs-5-2-remote-database-setting-problem/m-p/1752739#M228761 <HTML><HEAD></HEAD><BODY><P> Hello, Rishi,</P><P></P><P>Well, it's hard to say what problem could you encounter without seeing logs <span class="lia-unicode-emoji" title=":winking_face:">😉</span> 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.</P><P></P><P>Cheers, Irina</P><P></P><P>---</P><P>PS: Please, rate helpful posts!</P></BODY></HTML> Wed, 09 Nov 2011 12:35:10 GMT iilyinas 2011-11-09T12:35:10Z ACS 5.2 remote database setting problem https://community.cisco.com/t5/network-access-control/acs-5-2-remote-database-setting-problem/m-p/1752736#M228662 <P>Hello everyone,</P><P></P><P>I have installed ACS 5.2 appliance and try to backup report to remote database(MS SQL Server 2005) using remote database settings.</P><P>But the database is empty and the job in scheduler is failed.</P><P>So I check MonitoringAndReportingScheduler.log and found the log message in the attached file.</P><P>I try to find out answer in Cisco Support Community but found nothing.</P><P>But I google an article almost the same condiction as mine.</P><P><A href="http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_26931183.html" target="_blank">http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_26931183.html</A></P><P></P><P>I wonder what database configuration should I alter to meet the requirement of this report backup.</P><P>Because there is nothing about database in ACS configuration guide.</P><P>Does anyone succefully using this function?</P><P>What does "</P><P> I have changed database collation from SQL Latin to no SQL and it's working." in the article mean?</P><P></P><P>Thanks in advanced.</P> Mon, 11 Mar 2019 01:24:48 GMT https://community.cisco.com/t5/network-access-control/acs-5-2-remote-database-setting-problem/m-p/1752736#M228662 Mason Tu 2019-03-11T01:24:48Z Re: ACS 5.2 remote database setting problem https://community.cisco.com/t5/network-access-control/acs-5-2-remote-database-setting-problem/m-p/1752737#M228708 <HTML><HEAD></HEAD><BODY><P>Hi, Mason,</P><P></P><P>It's most probably because of the <STRONG>CSCtk83179 ACS 5 View export to remote SQL DB not working</STRONG>.</P><P>You have to wait for ACS 5.3 or patch 7 for ACS 5.2.</P><P></P><P>Cheers, Irina</P><P></P><P>---</P><P>PS: Please, rate helpful posts!</P></BODY></HTML> Sat, 17 Sep 2011 06:48:47 GMT https://community.cisco.com/t5/network-access-control/acs-5-2-remote-database-setting-problem/m-p/1752737#M228708 iilyinas 2011-09-17T06:48:47Z ACS 5.2 remote database setting problem https://community.cisco.com/t5/network-access-control/acs-5-2-remote-database-setting-problem/m-p/1752738#M228742 <HTML><HEAD></HEAD><BODY><P> We tried yesterday with 5.3, doesn't look better ...</P></BODY></HTML> Wed, 09 Nov 2011 09:53:58 GMT https://community.cisco.com/t5/network-access-control/acs-5-2-remote-database-setting-problem/m-p/1752738#M228742 rishi.sumbal 2011-11-09T09:53:58Z ACS 5.2 remote database setting problem https://community.cisco.com/t5/network-access-control/acs-5-2-remote-database-setting-problem/m-p/1752739#M228761 <HTML><HEAD></HEAD><BODY><P> Hello, Rishi,</P><P></P><P>Well, it's hard to say what problem could you encounter without seeing logs <span class="lia-unicode-emoji" title=":winking_face:">😉</span> 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.</P><P></P><P>Cheers, Irina</P><P></P><P>---</P><P>PS: Please, rate helpful posts!</P></BODY></HTML> Wed, 09 Nov 2011 12:35:10 GMT https://community.cisco.com/t5/network-access-control/acs-5-2-remote-database-setting-problem/m-p/1752739#M228761 iilyinas 2011-11-09T12:35:10Z ACS 5.2 remote database setting problem https://community.cisco.com/t5/network-access-control/acs-5-2-remote-database-setting-problem/m-p/1752740#M228794 <HTML><HEAD></HEAD><BODY><P> We opened a case.</P><P>Here's the message in the scheduler :</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 0cm; padding: px;" width="0"><TBODY><TR><TD style="padding: 0cm;"><P>ExportDataJob</P></TD><TD style="padding: 0cm;"><P>Remote Database export Utility</P></TD><TD style="padding: 0cm;"><P>System</P></TD><TD style="padding: 0cm;"><P align="center" style="text-align: center;">Wed Nov 09 07:30:01 CET 2011 </P></TD><TD style="padding: 0cm;"><P align="center" style="text-align: center;">Export Data run Failed.</P></TD><TD style="padding: 0cm;"><P>Failed</P></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 09 Nov 2011 12:58:39 GMT https://community.cisco.com/t5/network-access-control/acs-5-2-remote-database-setting-problem/m-p/1752740#M228794 rishi.sumbal 2011-11-09T12:58:39Z