1217597 - Error: 'Logon failed. You do not have the necessary rights to design against the SAP system', when attempting to create a report in Crystal Reports

SAP Knowledge Base Article - Public

1217597 - Error: 'Logon failed. You do not have the necessary rights to design against the SAP system', when attempting to create a report in Crystal Reports

Symptom

  • Error: 'Logon failed. You do not have the necessary rights to design reports against the SAP system.' or
  • Error: 'Login failed. You do not have the necessary rights to design reports against the SAP system.'
  • In Crystal Reports when attempting to create a new report off an SAP data source, it displays the error the user does not have necessary rights.
  • Other users can connect, refresh and create new report off an SAP data source.

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Crystal Reports, attempt to create a report off an SAP Table, Cluster or Function.
  2. Select the SAP system to connect to.
  3. In the SAP Logon window, enter the SAP user name and password.
  4. It then displays the following error message:

"Logon failed. You do not have the necessary rights to design against the SAP system."

Cause

  • User does not have the appropriate authorizations to perform the action requested on the SAP system.
  • User may have some of the authorizations, but their role is missing one or more authorizations on the SAP system.

Resolution

  • To be able to report off an SAP data source in Crystal Reports, request the SAP System Administrator to set the appropriate authorizations for the user.

For a list of authorizations that are necessary for each type of SAP connection, consult the document:

BusinessObjects XI Integration for SAP Installation Guide.

In the "Authorizations" chapter, there is a description of each authorizations needed for each type of connection and actions.
Note: Even though the document was written for XI 3.1, the information is valid for Crystal Reports 2008, 2011, 2013 and 2016.

  • In addition to the authorizations specified in the SAP Integration Kit Installation Guide, the following authorizations are required:
       
    • For Authorization object: S_RFC with Field name: RFC_Name.
      According to the installation guide the values should be: SYST, /CRYSTAL/OPENSQL
      • Additionally you will need the value: SUSR as well.
           
    • For Authorization object: ZSEGREPORT with field name: ACTVT.
      According to the installation guide the value is: 02 (Change)
      • Additionally you will need the value: 01 (Create or generate) as well.
          
  • Note: If the authorization object doesn't exist on your SAP System, ensure you have loaded the SAP Integration Kit Transports for the version of Crystal Reports and SAP Integration Kit you are using. The SAP Integration Kit Transports will load the required functions and authorization objects that are necessary to connect to the SAP System from Crystal Reports.

Keywords

CR, CRYSTAL REPORTS SAP, LOGON FAILED Crystal Reports SAP R/3 OpenSQL Driver Error , SAP ERP, SAP ECC , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 2013 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2

Attachments

xi3-1_bip_sap_install_en.pdf