Skip to Content
author's profile photo Former Member
Former Member

cockpit Widgets and Integration services

Hello,

I tried to ticked the option in General Settings to enable Widgets. The error told me I needed integration services installed. I have then installed B1 Integration Component. That now allows me to tick the box to enaalbe widgets.

But every time I log into SAP i get the error "Integration Services authentication failed"

Any help appreciated.

Thanks

Naomi

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Jun 11, 2012 at 05:21 PM

    Hey Naomi,

    I actually made a video that walks you through installing the B1if and getting the SAP dashboard widgets up and running. I discuss all of the issues mentioned in this thread and hopefully it is just what you need.

    http://businessonetraining.com//content/b1-integration-service-installation-demonstration

    Best regards,


    jmsignature.png (14.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 13, 2012 at 04:01 PM

    Hi,

    Check these if you get any help :

    http://scn.sap.com/thread/1884315

    http://scn.sap.com/thread/2137828

    Kind Regards,

    Jitin

    SAP Business One Forum Team

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 13, 2012 at 05:09 PM

    Hi,

    you may use the solution in this following sap note to solve your problem:

    1670645 - SAP Business One Integration Service authentication failed with trusted SQL connection Version 1 Validity: 05.01.2012 - active Language English

    Content: Summary | Header Data | References | Validity


    Symptom

    The trusted connection method is used in SAP Business One when connecting to the MS SQL server according SAP note 677884. During the Business One start up the following error happens:

    “SAP Business One Integration Service authentication failed. Log off from the application; then log on and try again. If the problem persists, contact your system administrator.”

    The authentication monitor in B1if (Monitoring -> Authent. Monitor -> press the Authentication info button for sap.Xcelsius scenario package) contains the following error message:

    “Unknown DB error happened”


    Cause

    Due to this complex configuration the dashboard authorization requires trusted SQL connection method for the customer DB SDL’s entry.


    Solution

    1. Add the user account, which is used for the trusted license server connection account to the SQL server's Security -> Logins part and assign sysadmin privileges for it. Instead of using the windows users group.
    2. Use the same windows account for executing the DI Proxy, Event Sender and the SAP Integration services via Start => Settings => Control Panel => Administrative Tools => Services. Double click the service. Click the Log On tab page. Check the radio button 'This account'.
    3. Restart all services related to the B1if.
    4. Set the trusted connection method in the SDL\company entry

    For more details on managing security in SAP Business One 8.8, please refer to the Administrator Guide_SQL.pdf and to the SAP note 677884.


    Other terms

    Authorization, restrict, SQL, SAP business One, Dahsboard, B1if, B1ic, Integration Service, authentication failed, trusted connection, NT Authentication,

    Header Data

    Released on 09.01.2012 02:08:43 Release status Released for Customer Component SBO-INT-DAB Dashboards Other Components

    SBO-INT-B1IF SAP Business One integration framework

    Priority Recommendations/additional info Category Consulting

    References

    This document refers to:

    SAP Business One Notes 677884 How to Restrict users to certain databases

    Validity

    Software Component

    Version

    SAP BUSINESS ONE

    8.8

    8.81

    8.82

    Good luck 😊

    Rgds,

    JimM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 13, 2012 at 05:12 PM

    1. B1i user password must be the same.

    2. Also Test the connection of the B1DI settings.

    Also see

    Trouble shooting note

    https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3136313934323226

    Finally, if you are using SQL Server Express, and you did not set it up via the SAP Supplied document for setting us SQL Server Express, you will have to add the instance of the database (ie <servername>/SQLEXPRESS)


    B1iUser2.jpg (87.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 11, 2012 at 10:30 AM

    Hi all,

    I have successfully installed SAP B1 Integration framework on SAP 8.82 PL6, but as i login into SAP B1 i get the error : SAP Business One Integration service authentication failed. Log off from the application; log on and try again. If the problem persists, contact your system Administrator"

    Tried almost everything, reinstallation, pswd change, DB detachment and reattachment. still no sussess.

    Trying since last two weeks.

    Regards

    Sonil

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2012 at 07:51 AM

    Hi Naomi,

    Just uninstall B1if and install again, Mark one point when installing fresh i.e SQL server give entire path < Servername>/ <Instancename>

    e.g Srujal\SQLEXPESS

    I am happy to see 8.8.2 dashboard working fine.

    Thanks,

    Srujal Patel

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.