407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 6318)

SalesLogix - Error: In the SalesLogix UserSecurity table, unrecognized values for UserType 'W' detected.

This information applies to :

Article ID
6318

Created/Updated
August 18, 2006

Category
SalesLogix


Are you using the most current release of QuoteWerks?
Version 5.5 Build 1
Issue:
When logging into QuoteWerks or when attempting to setup the SalesLogix link you receive a message box with the following message:

Error: In the SalesLogix UserSecurity table, unrecognized values for UserType 'W' detected.


Cause:
SalesLogix user accounts with a User Type of "Administrator" are not allowed to be used with the QuoteWerks/SalesLogix integration.


Solution 1:
If you are attempting to use the SalesLogix ADMIN user account to setup the integration in QuoteWerks please choose a different account.


Solution 2:
You will need to change the User Type of the SalesLogix user account to something other than "Administrator".

One tested method for accomplishing this is as follows:
1) Open your SQL Server Enterprise Manager
2) Expand your SalesLogix Database
3) Return all rows for the USERSECURITY table
4) Modify the "TYPE" field for the user account in question to reflect N instead of W.
5) Restart QuoteWerks and you should now be able to complete the SalesLogix integration Setup

New Search