SQLXPRESS: Logon rejected by server. GUARDIAN error 2 from PROCESS_CREATE( )

SQLXPRESS: Logon rejected by server. GUARDIAN error 2 from PROCESS_CREATE( )

  1. If the ACMAP file is not present, the error indicates that the SQLX program could not be started directly.  Check that the program exists and is secured in a manner that allows the user logged on to the SQLXPress client to start that program.
  2. If the ACMAP file is present, the SAS starts SQLX via the XYGATEAC program, configured in the ACCESSCONTROL section of the SQXINI, which should appear like:

                 [ACCESSCONTROL]
                        ACTIMEOUT=30 
                        ACPROGRAM=$SYSTEM.XYGATEAC.XYGATEAC
                        ACCOMMAND=-n%NAME %CLASS
 
  1. XYGATE-AC uses the definitions in the ACMAP file to use XAC commands defined to a given user to start the SQLX under the appropriate credentials.  For example, the ACMAP could look like:
                                 sqlxpr.* sqlxpress-auto-dba

This would mean that users in the SQLXPR group would apply the XAC SQLXPRESS-AUTO-DBA command to start the SQLX under a different Guardian user.  Users outside of the SQLXPR group would not use XAC, starting the SQLX directly (see #1, above).

If the logged-on user does match the ACMAP entry, review the XAC command to verify that it is defined and will start the SQLX.




If you are unable to locate the solution needed or if you need additional assistance please Click Here to open a case from our Customer Care Portal.