move Monitoring from Derby Database to the Audit Database - sbo file update

[Former Member]

Hi,

I have reviewed the following note:

1741961 - How to move Monitoring from Derby Database to the Audit Database in BI4.0 SP4

I want to move the monitoring db to Audit DB. It states I need to update the SBO file.

I am using SQL Server 2008 as the audit DB so do I just need to make sure "SQL Server 2008" is stated in the dbo file which it is?

See below extract?

    </Defaults>

    <DataBases>

        <DataBase Active="Yes" Name="MS SQL Server 2008">

            <Aliases>

  <!-- You can add an alias here if you are using some connections that are defined with an older database engine -->

  <Alias>MS SQL Server 2005</Alias>

  <Alias>MS SQL Server 2000</Alias>

  <Alias>MS SQL Server 7.x</Alias>

  <Alias>MS SQL Server 6.5</Alias>

  </Aliases>

  <Libraries>

Cheers,

[amitrathi239 · Accepted solution]

Hi,

check attached link.you can compare the SBO file.

[Former Member]

Hi Leo,

Below is the change that you need to make in the SBO file:

<DataBase Active="Yes" Name="MS SQL Server 2008">

<Aliases>

<Alias>MS SQL Server</Alias>

</Aliases>

<Libraries>

<Library>dbd_wmssql</Library>

<Library>dbd_mssql</Library>

</Libraries>

<Parameter Name="Extensions">sqlsrv2008,sqlsrv,odbc</Parameter>

<Parameter Name="CharSet Table" Platform="Unix">datadirect</Parameter>

<Parameter Name="Driver Name">SQL (Server|Native Client)</Parameter>

<Parameter Name="SSO Available" Platform="MSWindows">True</Parameter>

</DataBase>

Refer the below Admin guide (page: 653 😞

https://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp1_bip_admin_en.pdf

Regards,

Medha