Showing results for 
Search instead for 
Did you mean: 

Unable to connect to XL Reporter

Former Member
0 Kudos

Hi All

A client is experiencing difficulty connecting to XL reporter.

They were having issues before and thought it was because of the patch they were running, but could not get an error just would not work. They upgraded to patch 42, 2007 version. but is having issues as well.

The error she got is

Unable to connect to XL Reporter

Error! User Authentication failed!

Cause: Invalid use of Null

Does she need to reset the permissions?

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos


This issue occurs because the old stand-alone version of XL Reporter previously has been installed on the company database you are trying to use. This version used the partner code SAP, while the add-on version uses the code SBOOEM. The installation does not recognize this as an upgrade.

In order to solve the issue please do the following steps:

1. Start the SQL Management Studio and go to "Object Explorer".

2. Browse down to your Business one database, expand and choose tables.

3. Right click the table "XRDBV" and choose "open".

4. In the column 'Partner' change the text from SAP to SBOOEM and press Enter.

5. Close the "SQL Management Studio" and start the XL Reporter. The XL Reporter information in the database should now be upgraded.

Please find SAP note [847981|], which gives a detailed description of this issue.

hope it helps,



SAP Business One Forum Team

Answers (2)

Answers (2)

Former Member
0 Kudos


Check these notes


924561 853343 853821




Former Member
0 Kudos

Thanks alot

Former Member
0 Kudos

Check this SAP Note: 847981 Unable to connect to XLR after installation