Saleslogix Slxclient and Sdata Configuration Error..Help Needed

Hi All,

I am facing an configuration issue in my server. I have upgraded our LAN SLX from 7.5.2 to 8.3.2.

The upgrade went smooth and everything in LAN client works fine.

Also, in Application Architect i have built and deployed the project successfully with out any errors. The following is the issue i am facing when i try to login in to Web Client.

It is showing Unauthorized ASP.NET error page.Please note that at this point i have only anonymous authentication enabled on IIS.

When i also enabled basic and forms authentication in IIS for Slxclient, then when i try to access the http://localhost:3333/Slxclient , it is asking for windows pop-up (though my intention is not make windows authentication) and when i pass webdll and password to that pop-up it is now showing the login page and when i login everything inside the portal works fine

Now i have similiar problem with sdata (i need this for my xbar configuration) and when i make basic and forms authentication in IIS enabled for sdata in IIS it is not working.

Can someone help me in sorting out this please?

Why i am getting pop-up for webdll user every time i access login page?

What authentication i need to keep for sdata to make it accessibly work?( The reason why i say accessibly work is may be sdata is working inside my slxclient fine that's why i can see all my dashboards and other group features working inside my slxclient portal but i am unable to access it externally because of some setting in configuration)

Please help

Thanks,

Ram

Find more posts tagged with

Infor CRM - Developer General Discussions

Comments

stefan-semlak

Have you added the site to your "Trusted Sites"?

unknown

Have you set up the INFORcrm user ADMIN to be windows Authenticated with your domain user webdll?

unknown

I added it now and the issue remain same. If i enable forms,basic and anonymous authentication, it is asking for windows user pop-up where i am passing WebDll user and working fine. but if i only enable anonymous authentication it is directly showing 401 unauthorized error..

unknown

No i didn't do that. I am not looking for windows authentication for any users as of now. even though do we need to set up windows authentication for admin user?

stefan-semlak

I don't think you want both Anonymous and Basic authentication in the SLXClient. There are also some Internet Options you may need to set if that doesn't work.

stefan-semlak

Set only Anonymous and Forms Authentication.

unknown

When i set only forms and anonymous.. i am facing following error

HTTP Error 401.2 - Unauthorized

You are not authorized to view this page due to invalid authentication headers.

Detailed Error Information:

Module IIS Web Core

Notification AuthenticateRequest

Handler ExtensionlessUrlHandler-ISAPI-4.0_32bit

Error Code 0x80070005

Requested URL localhost:3333/Slxclient

Physical Path C:inetpubwwwrootSlxClient

Logon Method Not yet determined

Logon User Not yet determined

Thanks,

Ram

stefan-semlak

Have you modified the web.config files for either the SLXClient or SData portals? You may need to check to make sure that those methods are enabled within those documents.

unknown

this is the first time i deployed 8.3 web portal and i have not made any changes to web.config file either in slxclient or in sdata? Do we need to do any changes by default when we need to run it with out windows authentication for first time as part of implementation plan?

unknown

InforCRM implementation Guide.pdf has a section for Installing the Web Components and it instructs to configure webdll user for Windows Authentication by binding it to ADMIN.

Excerpt:

Configuring the WebDLL User for Windows Authentication

You must configure the WebDLL user for Windows Authentication to allow the Infor CRM Web Client to open a

connection to the CRM database. This task must be completed even in installations that do not include Windows

Authentication for Infor CRM Network and Web Client users.

stefan-semlak

If you haven't ever modified the web.config folder, then you shouldn't have to for a non-Windows authentication. Let's back up for a second. Are you sure that your server is properly configured and you have all the prerequisites installed?

unknown

Yes... the reason why i am sure is my lan client is working fine and my admin is working fine which means that i don't have any issues with connection manager. Also, when i installed project back up of 83 i make sure i have checked the schema check box in project restore screen and i have properly installed 8.3 upgrade1 and upgrade2.

The only problem i face is when i give Anonymous, Basic and forms authentication enabled the site works fine with prompting of webdll user or admin user credentials which will go to login page of slx client. when igive proper slx admin credentials i can see everything functional inside my web client.

But when i remove all other authentications as per implementation guide i don't see it working and showing below error

HTTP Error 401.2 - Unauthorized

You are not authorized to view this page due to invalid authentication headers.

Detailed Error Information:

Module IIS Web Core

Notification AuthenticateRequest

Handler ExtensionlessUrlHandler-ISAPI-4.0_32bit

Error Code 0x80070005

Requested URL localhost:3333/Slxclient

Physical Path C:inetpubwwwrootSlxClient

Logon Method Not yet determined

Logon User Not yet determined

My App pool settings are 32 bit enabled with custom user identity mapped to webdll. Also the mode i set is classic.

Thanks,

Ram

unknown

I am experiencing the same issue. However - I didn't upgrade - it just started failing. I have added a helloworld.html and can access that file as long as it isn't inside of one of the virtual directories. All Directories are set to WebDll, and Login.aspx page is accessible, but logins fail. Network profiling, SLX profiling, IIS Logging and Event Log do not capture anything of actual value.

The newest Windows update is malicious Tool updates - but I am having issues uninstalling it to see if it is the problem.

Windows 2012 R2, SLX Version 8.1 with snc, sc/ wm 3 & 3b

stefan-semlak

Your managed pipeline should be "Integrated." If that doesn't fix it, I would file an incident and defer to Infor Support. I would also ensure that both .NET 3.5 and 4.5 are enabled in the Server Manager.

unknown

Hi,

So first, make sure your App Pool runs under a user with the correct user rights.

To make it easy, give it local admin rights.

Then, make sure your app pool is configured to pipe line mode integrated (not classic).

Then go to your web site and siable all authentifications and only left anonymouse on.

Click on edit for anonymouse authentification and make sure, that you use the same user for the anonymouse authentification then your app pool is running under.

Then do a iis reset and try again.

Also make sure, that you install all asp.net stuff on your server.

So in server manager make sure the apropriacte features from the application server role and the web server role are installed.

Make sure, you have not installed webdav things.

Thanks! Alexander

unknown

All issues got resolved now and slxclient,sdata and xbar is working fine now. But when i try to give the url to infor crm connector options in outlook it is giving weird error.

Also, when i try to login in to saleslogix desktop manager i am getting the below shown error

However, i am able to login in to xbar and it is working fine. Also, slxclient is working fine (including all sdata grids)

Please suggest ... i have installed 8.3 and all updates (up to update 5 which includes webcore update, snc update and web model update successfully and build is success and deployed without any issues.

Regards,

Ram

unknown

Hi,

Can you describe the issues?

Can you record mails to infor CRM?

Thanks! Alexander

unknown

No i am unable to record emails in outlook. Even outlook integration is not working either.

The problem is with APPIDMAPPING table and it's foriegn key in systeminfo table. I have gone through different posts and found that when ever we are updating the SLX from 7 to 8.3 the APPID mapping table will not get new record until you install all the service packs of 8.3 (all 5 updates of 8.3).

Also, i see one kb where it contains sql for inserting record for APPIDMAPPING table.

The moment i installed all updates of 8.3 i got to see new record in APPIDMAPPING table and still the issue with the outlook integration remains same.

But the moment i updated the systeminfo table with appid everything starts working fine

Thank you everyone for the help

Below is the article i referred for inserting record in to APPIDMAPPING table

WARNING: The following requires knowedge of SQL databases and should only be executed by persons who are qualified.

WARNING: Support always advises making a full database backup before running any update statements.

NOTE: In testing it does not appear the insert statement can be run via Execute SQL in the Infor CRM LAN Administrator.

Change the “USE” name in the following statement to the database you intend to run this process on.

After your changes to the script Execute against the database using SQL Management studio.

--This statement removes the existing record

USE [Your Database name here]

GO

Delete from [sysdba].[APPIDMAPPING] where APPID = 'QSYST0000000'

Go

Verify the record for APPID = 'QSYST0000000' is gone by running the following SQL Statement in SQL Management Studio.

Select * [sysdba].[APPIDMAPPING] where APPID = 'QSYST0000000'

Now that the previous record is gone, Change the “USE” value in the statement below to reflect your database.

After your changes to the script Execute against the database using SQL Management studio.

--This statement recreates the record and sets the default values found in an Eval database.

USE [Your Database name here]

GO

INSERT INTO [sysdba].[APPIDMAPPING]

VALUES

('QSYST0000000','Saleslogix','http://<server>:<port>/sdata/slx/gcrm/-/',

'ADMIN',NULL,'ADMIN','2013-12-19 09:54:36.000','ADMIN',

'2013-12-19 09:54:36.000','T',NULL,NULL,NULL,NULL,'T',NULL,'F',NULL,NULL)

GO

Also, we need to update the systeminfo table with new APPID that we inserted using above statement, otherwise the issue remain same.

Thanks,

Ram

Copyright © 2025 Infor. All rights reserved.