I had 2 AAC servers connected with the farm information on a SQL 2000 server. Due to end of life I had to migrate the database to a new SQL 2005 server. This is how I did it;
1. I backed up the database (usually called by default the name of your AAC farm) on the SQL 2000 server and restored it onto SQL 2005.
2. Open the AAC Server configuration utility. Go to ‘Services’ and stop all services.
3. Go to ‘Server Farm Information’ and change the name of the SQL server.
4. Restart the services.
5. Check the log/event logs for any unusual behaviour.
6. I bounced the server(s) to be sure.
6 comments
Comments feed for this article
February 9, 2010 at 3:40 pm
Frederic Roger
Hi Garet
I see you old post in 2007
http://gmdavies.co.uk/2007/12/13/migrating-a-citrix-advanced-access-control-database-from-sql-2000-to-sql-2005/
Have you succes to upgrade database AAC 4.5 SQL200 to SQL2005 ?
Can you give us your process ? Thank for you help
Regards
Frederic Roger
February 9, 2010 at 6:57 pm
Gareth M Davies
As far as I recall the steps specified were enough to do the job. Do you have any specific problems?
February 10, 2010 at 9:59 am
Frederic Roger
No, because we are not start our migration !!!! We are search only information for the process !!! In your memory perhaps
Thank a lot Gareth.
Regards
Frederic Roger
May 25, 2010 at 1:29 pm
Sukhjit Singh
Thanks for the information. However I am getting an error when I try this.
I have copied the database to a new SQL 2008 server and then gone through the process. Every time I change the server name I get the following error
” The farm ‘XXX’ cannot be joined on ” ”
I have tried to move the database to another sql server 2005 and I get the same error.
We are on CAG 4.5. Any help would be welcomed.
May 25, 2010 at 1:31 pm
Sukhjit Singh
Sorry the comments changed my error message
It is as below
” The farm ‘XXX’ cannot be joined on ‘server_name’ ”
where XXX is the name of the farm and the server_name is the name of the database server
Thanks
July 26, 2010 at 9:47 am
Frederic Roger
Hi Sukhjit
For make simple.
1) Create in your SQL2008 au new database for the new Farm AAC2
2) Export all Parameter in your first Farm AAC1 with.
– Open Console AAC1
– Select AAC1 Farm, and in the context > All Task > Export Farm > %Your Path%AccessGatewayConfigurationData.cab
3) Create a new farm AAC2 on your new Databae SQL2008
4) Import configuration AAC1 with AccessGatewayConfigurationData.cab on your AAC2
5) Reaffect All AAC Server in the new Farm AAC2
PS: Sorry for my English
Regards
Frederic