CSA 5.2 - Remote DB - Pointing to a new DB

joseph.hamilton · ‎07-11-2007

We're in the early phases of a CSA 5.2 migration from 5.0. We're using a "temporary" database server to get hopped over to CSA 5.2, after which point the org wants to rebuilt the original DB server with SQL Server 2005, copy over the DB, and re-point CSA to it.

I can't find anything in the release notes about pointing to a different SQL DB, nor can I find any place in the CSA MC where you can specify your DB connection parameters.

Any thoughts on how to do this? This would also be helpful to know for creating a Disaster Recovery plan for CSA. I don't think Cisco TAC can help on this one.

joseph.hamilton · ‎07-16-2007

It would appear I spoke too soon about Cisco TAC...I'm attaching the document they gave me. They said the only caveat they had was to make sure we used the 1433 TCP port for SQL Server.