Skip to Content
0
Former Member
Feb 17, 2011 at 01:41 AM

cannot change database in CMS, Pls help.

140 Views

Hi Expert,

i'm trying to change database for CMS from MySql 5 to MSSql 2005 in BO Edge 3.1.

Although, i already created and tested the ODBC for MSSql. it went succeed.

i followed the instruction in the admin guide :

1. Use the CCM to stop the Server Intelligence Agent (SIA).

2. Select the SIA and click Specify CMS System Database Data Source on the toolbar.

3. In the Configuration tab of the "Properties" dialog box, under CMS Data Source, click Specify.

4. The remaining steps depend upon the connection type you selected:

If you selected ODBC, the Windows "Select Data Source" dialog box appears. Select the ODBC data source that you want to use as the CMS database; then click OK. (Click New to configure a new DSN.) When prompted, provide your database credentials and click OK.

If you selected a native driver, you are prompted for your database Server Name, your Login ID, and your Password. Provide this information and then click OK.

The CCM notifies you when the CMS database setup is complete.

5. In the "Properties" dialog box, click OK.

6. Restart the Server Intelligence Agent.

It still cannot connect when i was trying to login to manage servers.

is there any other step did i miss?or any possibility?

Many thanks.

Regards,

Y Permana.