Create CMS database on existing SQLServer2005

[Former Member]

Dear all,

i could like to install BOE3.1 but cross error (STW00226).

i using existing database during the installation.

so i guess the error occurs of didnt setup CMS on existing database.

May i know how to setup CMS database on SQLServer2005?

Please provide step by step of the procedure.

appreciate for your reply.

[former_member142702]

Hi Marcus,

what kind of O/S are you installing BO on?

Regards,

Stratos

[Former Member]

Thanks Stratos for reply.

i need to install on window os.

Regard,

Marcus

[former_member142702]

Hi

which version of Windows?

Regards,

Stratos

[Former Member]

sorry for didnt provide the full information.

our server is using window server 2003 sp2.

with SQL server 2005 as the database.

Regard,

Marcus

[former_member142702]

Hi,

the CMS database should be initialized automatically on the existing database you provided. All you have to do in advance is to create a database instance and a user in this instance. What exactly is the error message you get and when exactly (installation step) do you get it?

Regards,

Stratos

[Former Member]

the time i get this error message is on the time of the installation require to setup the existing database.

i choose Microsoft SQL Server (ODBC) and browse the database. then cross the error.

May i ask another question? actually i could use 'web service connection' on xcelsius to collect the FM return.

by using 'web service connection'. do BOE required to install on server? sorry if this is the stupid question. because i'm new on BO and xcelsius.

[former_member142702]

Hi,

do you use an 64bit or a 32bit of windows.

Please mind my ignorance, but what does FM stand for in your postings?

Regards,

Stratos

[Former Member]

My server is using 32 bit.

the FM i means is the SAP R3 Function module.

[former_member142702]

Hi

you need BOE if you want to publish your dashboard in the BOBJ portal in order to make it available to your SAP users. This way you can also implement SSO ie. the user logons with her/his SAP credentials in the BOBJ portal and invokes XCelsius, which fetches the data from the SAP R/3 system (through LiveOffice) using the user's sap credentials.

Can you please confirm that the DB user you createdis authorized to access and create tables in your database instance. Can you check also if there are some tables created during the installation in your database?

Regards,

Stratos