cancel
Showing results for 
Search instead for 
Did you mean: 

cockpit Widgets and Integration services

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

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

former_member746980
Participant
0 Kudos

Hi,

Authentication error resolved.

Now on clicking dashboard error comes.

How to work for Error:

SAP B1iP detected an error

Emitted HTTP Code

500 Internal server error.

Former Member
0 Kudos

Hi Sonil.

Please post a new thread for your own question. It is impolite to post on other's posting.

Thanks,

Gordon

former_member746980
Participant
0 Kudos

Hi Gordon

Will take care of this. Thanx.

Regards

Sonil

0 Kudos

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,

former_member746980
Participant
0 Kudos

Hi John,

Thanks for providing this Video Link. With this i could get through with the login issue of Microsoft services.

Unfortunately, when i try to connect to dashboard in B1 8.82 PL6 it throws me an error for :

SAP B1iP detected an error

500- Internal Server error

Internal reason

Did not supply an appropriate user - ID Integer (param-6)

...

Can you guide me on this.

Regards

Sonil

0 Kudos

Hey Sonil,

usually 500-Interenal Server errors are related to IE not trusting a certificate or something like that. I'll have to reproduce it on my end to be sure. I'll keep an eye for the new thread with this question and update when I get a chance to test myself.

Best regards.

former_member746980
Participant
0 Kudos

Hi,

Thanx for your reply.

I had resolved the issue.

I reinstalled B1iC by running the setup as administrator. and it was all success. on way to create my own dashboards :-).

Regards

Sonil

Former Member
0 Kudos

Hi John,

May I know how to bring back my SBODemoUS database ?

Thank

Regards,


Leow

former_member746980
Participant
0 Kudos

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

Former Member
0 Kudos

Hi Sonil,

Did you done all what is mentioned under solution within SAP Note 1670645 - SAP Business One Integration Service authentication failed with trusted SQL connection.

Details of note are available in this thread it self.

Best Regards,

Samir Gandhi

former_member746980
Participant
0 Kudos

Hi Samir,

Thanks for quick reply.

I have 'sa' user with these settings.

Do i need to create same user credentials for both windows and Database.

As Service login used Windows account details.

Regards

Sonil

Former Member
0 Kudos

Hi Sonil,

Nothing wrong taking test !!!

Best Regards,

Samir Gandhi

former_member746980
Participant
0 Kudos

Hi

Any clue how can i resolve this issue "Authentication failure"

Regards

Sonil

former_member217514
Active Contributor
0 Kudos

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=69765F6D6F6465...

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)

former_member186095
Active Contributor
0 Kudos

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

jitin_chawla
Active Contributor
0 Kudos

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