Hi,
Currently the BO Production is pointing to a sql server but that server has been dedicated to other purpose and they want the BO Production (the CMS databse) to be pointed to new SQL SERVER( which is a production one).
Is there a way that i can reconfirgure the CMS database to use the new SQL SERVER?I know that we should modify the ODBC connectivity but how are the repository tables created on new SQL SERVER?
Is it possible at all to point to the new server?Does it involve a reinstall on BO production server again in order for it to create the repository tables in the new SQL SERVER database?
Go to the Central Configuration Manager, and stop the Central Management Server. Right click the Central Management Server and select Properties. On the Configuration tab specify a CMS data source and you will be given the options to attach to new CMS, copy current to new, and to re-initialize the current CMS. I think the second option is the one you want.
Hi,
Thankyou for the quick response.
As you specified i stopped the CMS and clicked on the SPECIFY button to select the DSN and it gave me three options
Slect a Data Source
Copy Data From Another Datasource
Recreate the Current Datasource
So, do i need to select the second option ,i mean do i need to copy the data from another datasourse(This option will destroy any information currently existing on destination data source)
Why would you have any data on the destination data source? That should be a brand new instance of the database as you have stated in your original post.
The BusinessObjects schemas should reside in their own instance of database, and not to share with any other application.
[quote:60a5f5f04c=“In the previous post, Dwayne Hoffpauir”]On the Configuration tab specify a CMS data source and you will be given the options to attach to new CMS, copy current to new, and to re-initialize the current CMS. I think the second option is the one you want.
[/quote]
Be careful if you ever add a second CMS to your system. Like when you upgrade hardware, …
When you link the CMS to the existing database it will change the cluster name to the name of your data source.
To delete the old machines you must leave the server running with the CMS shutdown and delete. If you don’t do that the old services will remain in the CMC View and can no longer be deleted
2 CMSs cannot share the same the same "repository or they are called clustered and you need specific licenses for that.
(BOB member since 2002-09-19)
(BOB member since 2004-01-16)
(BOB member since 2002-08-09)