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
Hi,
you may use the solution in this following sap note to solve your problem:
| ||||||||
|
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
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
SBO-INT-B1IF SAP Business One integration framework
References This document refers to: Validity Software Component Version SAP BUSINESS ONE 8.8 8.81 8.82
|
Good luck 
Rgds,
JimM
1. B1i user password must be the same.
2. Also Test the connection of the B1DI settings.
Also see
Trouble shooting note
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)
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
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
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
Hi Sonil,
Nothing wrong taking test !!!
Best Regards,
Samir Gandhi
Hi
Any clue how can i resolve this issue "Authentication failure"
Regards
Sonil
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,
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
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.
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
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
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.
Hi Sonil.
Please post a new thread for your own question. It is impolite to post on other's posting.
Thanks,
Gordon
