The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
SalesLogix v7.5 DB Eventing Service
Posted: 03 Oct 08 1:16 AM
|
Hello
Issue 1
All SalesLogix related services are running as a SLXService user, however for this service DB Eventing it does not start in a timely fashion, I am forced to run it as a local system account. Is there something i am missing.
Issue 2
The SalesLogix Web Portal works just fine. However for process orchestration, it launches the windows challenge response authentication for the portal, and on giving the relevant SLXService user authentication to the website it does not show the website. The deployment has worked fine however am not able to see the portal. The SLXClient is deployed under the default website as well as processhost has been deployed under the default website.
The processhost directory security when default deployed has Integrated Windows Authentication check box on. Post this this is the following error.
Access is denied.
Description: An error occurred while accessing the resources required to serve this request. The server may not be configured for access to the requested URL.
Error message 401.2.: Unauthorized: Logon failed due to server configuration. Verify that you have permission to view this directory or page based on the credentials you supplied and the authentication methods enabled on the Web server. Contact the Web server's administrator for additional assistance.
I try removing the Integrated windows authentication and then test the website. This is the website error that is coming out
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: No error message available, result code: DB_SEC_E_AUTH_FAILED(0x80040E4D).
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
What can be the possible issue as a result of this.
Regards
Kannan |
|
|
|
Re: SalesLogix v7.5 DB Eventing Service
Posted: 03 Oct 08 2:46 AM
|
Hi Kannan,
1: I had the opposite problem in Beta! It would not start with the default system user and I had start with my service user and it worked! It should be fine with local system user (I think!)
2: The answer to the challenge/response is not your slxservice user! It is "admin"! This is looking for your SalesLogix administrator username and password - not a windows username and password. You must have configured your Admin user to be linked to the SLXService user for Windows Authentication in the Administrator.
The steps are in the help file for App Architect. I've also given step-by-steps on them in the latest DevLogix.
Stephen
www.slxmaster.com
|
|
|
|
Re: SalesLogix v7.5 DB Eventing Service
Posted: 03 Oct 08 5:42 AM
|
Thanks Stephen, just to update
the first problem got rectified i.e. the DB Eventing Service has started off with the SLXService user
the second issue is the process host is a web directory under the default website and has been deployed seperately like the SalesLogix web portal.
I had applied the changes given in the architect help file, somehow it does not show the adaptors. I had associated all verbs in the configuration and edited the ashx file too
i am at the dead end. Any further clues?
Regards
Kannan |
|
|
|
Re: SalesLogix v7.5 DB Eventing Service
Posted: 03 Oct 08 12:35 PM
|
Hi Kannan,
Yeah, I know a small bit about the Process Host so I understand that it is a web directory.
Will you confirm that the authentication on the ProcessHost web folder is set to "Anonymous" and that "Windows Authentication is turned OFF.
What URL are you using to test your connection to the Process Host? Are you using http://server:port/ProcessHost/$system/adapters?
Stephen
|
|
|
|
Re: SalesLogix v7.5 DB Eventing Service
Posted: 07 Oct 08 4:54 AM
|
Yes Stephen
Confirming that the processhost web folder is set to anonymous to the webdll user and Windows Authentication is turned off.
I tried both the URL's i.e.
http://servername/processhost/$system/adaptors
and
http://vmdellslx72/ProcessHost/default.aspx
still shows me the nt challenge response, i enter the administrator user or any user for eg even webdll and the result error is
No error message available, result code: DB_SEC_E_AUTH_FAILED(0x80040E4D).
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: No error message available, result code: DB_SEC_E_AUTH_FAILED(0x80040E4D).
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Normally DB_SEC_E_AUTH_FAILED happens if the ADO was not propagated properly however here all the details of the ADO has been propogated due to which other portals are running such as SLX Client Portal and SLX Customer Service Portal
Regards
Kannan |
|
|
|
Re: SalesLogix v7.5 DB Eventing Service
Posted: 07 Oct 08 4:56 AM
|
Further inputs here is that all the SLX related websites such as SLXClient,SLXCustomerPortal,ProcessHost run under the default website under port 80. The other websites run fine. But for the ProcessHost it shows the error above.
Regards
Kannan |
|
|
|
Re: SalesLogix v7.5 DB Eventing Service
Posted: 07 Oct 08 12:19 PM
|
Hi Kannan,
One quick point - you have mentioned $system/adaptors above. The URL is $system/adapters ("e" instead of "o").
There is no /default.aspx handled so you are wasting your time.
You are also wasting your time trying to authenticate with the WebDll user. This is NOT an NT Challenge Response - it is a SalesLogix Challenge Response. You need to log in with "admin" as the username (or, for example if you are using SLX Eval, "lee", "lou", etc.)
Regards,
Stephen
|
|
|
|
Re: SalesLogix v7.5 DB Eventing Service
Posted: 08 Oct 08 12:18 AM
|
sorry it was a typo, indeed it is $system/adapters, i am not testing with the webdll user at the authentication page. Should have been more clear in my explanation.
the URL http://servername:portname/ProcessHost/$system/adapters that is used in my deployment is http://vmdellslx72/ProcessHost/$system/adapters
the Virtual Directory in IIS called ProcessHost has the following properties.
In the Directory Security Tab in IIS-> I check the anonymous use of it with the SLXService User in my case it is set as webdll, since the IUSR_MACHINENAME does not have sufficient rights to execute some scripts. I have also Unchecked the Integrated Windows Authentication.
Now when the above URL i.e. http://vmdellslx72/ProcessHost/$system/adapters is entered in the browser I continue to get the windows authentication dialog, hence it does not allow me to log into SalesLogix Process Host with any valid SalesLogix user.
Unless I fill the windows authentication with a valid windows user it does not allow me to progress. Now in my Windows User Accounts List I have Administrator and WebDLL. I try both these users in the above dialog(Windows Authentication), as a result i get the error
No error message available, result code: DB_SEC_E_AUTH_FAILED(0x80040E4D).
I am aware that in SalesLogix one needs to login with Admin/lee/lou for the eval db. Do you see any thing wrong here. |
|
|
|
Re: SalesLogix v7.5 DB Eventing Service
Posted: 08 Oct 08 2:41 PM
|
Hi Kannan,
I would suspect a problem with IIS. If you are absolutely sure that you have followed the steps.
What happens if you run the SLX Web Host install to create a brand new web site (e.g. on port 3333) and configure your SData and ProcessHost sites here.
DOuble-check that you are following the steps in the help file exactly.
Regards,
Stephen
www.slxmaster.com
|
|
|
|
Re: SalesLogix v7.5 DB Eventing Service
Posted: 22 Jul 09 3:39 AM
|
Resurrecting an old post just to point out that, from my own experience, the DB_SEC_E_AUTH_FAILED error is due to misconfigured SalesLogix Windows Authentication. I.e. you must enable the WebDLL user to auto-login as admin.
See "Configuring the WebDLL User for Windows Authentication" on the implementation guide for details.
|
|
|
|