cancel
Showing results for 
Search instead for 
Did you mean: 

BO 6.5 switching from SQL Sql Server 2000 to 2005

Former Member
0 Kudos

Need information for BO 6.5 on issues switching from Sql Server 2000 to Sql Server 2005.

Thanks in advance for any information!

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

As per product availability report of Business Objects 6.5.Sp4 is supported with Sqlserver 2005 you need to migrate to 6.5.Sp4 and there are some known issues with tables which are having underscores in Designer you cant see them in table browser while inserting.

I hope this helps, please let me know if you need anything further.

Thanks,

Ram

Former Member
0 Kudos

If you're migrating the Repository database as well from SQL 2000 to SQL 2005, you need to also to update the security files by taking the steps below:

1. Stop the server

2. Rename the existing security files (bomain.key and bomain.lsi)

3. Run the Safe Recovery to regenerate a new bomain.key

4. Run the Scan, Repair and Compact of the Repository

5. Copy the new bomain.key to the locdata located at u2026\nodes\<server>\<cluster>\locdata

Regards,

Jeff

Former Member
0 Kudos

This response comes late, but in my limited experience with SQL Server 2005, I didn't find any known issues. Something to be careful of is the default collation when setting up the new DB server. Mismatches between case sensitivity and potentially other settings might cause reports to fail.

harjeetjudge
Product and Topic Expert
Product and Topic Expert
0 Kudos

Apparently Sql Server 2005 has issues with '_' in table names. These tables may not display properly in designer and you may have to apply SP2 for Sql Server 2005. The following kbase has some more information:

http://support.microsoft.com/kb/294875/en-us

You should also edit your universe connections and select MS SQL Server 2005 ODBC/OLEDB drivers rather then SQL Server 2000 drivers.