Skip to Content
Former Member
Apr 25, 2013 at 09:57 PM

Business Objects XI R2 changing connections



I am using Business Objects XI R2 , we are going to move from SQL Server 2000 to SQL Server 2005. I followed all the steps already mentioned and discussed in the forum namely

1) Create a copy of CMS repository database schema (SQL 2000) in SQL 2008 - DBA will do this.

2) boeadmin should have access to these new db -- has access

3) Create ODBC connection, test its connectivity -- works

4) Open CCM (one by one), stop CMS. -- stopped all

5) Right click on CMS in CCM and go configuration tab, Choose the option "select a datasource" and select SQL server(ODBC). Point to the new ODBC (Already created in control panel). -- Done

6) Start CMS -- working fine

Everything is alright but the schedules are not being picked up. Which means users who have scheduled reports will not have those schedules anymore. This is not what I want, when I change the connection from old db to new db (both dbs are clones -- verified this) why is the new connection not picking up the schedules ??

Kindly share your ideas