The SQLXPress installer fails to create SQLXPress DB in SQL/MX with error 1017

The SQLXPress installer fails to create SQLXPress DB in SQL/MX with error 1017

Logon as a userID that has been granted CREATE CATALOG permission to the SQLXPress installer or to run the SETUPX program.
Or grant permissions to create an SQL/MX Catalog.

The example below grants the privilege to create a catalog to user "SQL.USER1"
Example:
GRANT CREATE CATALOG TO "SQL.USER1";

Note: the GRANTEE on the PRIVILEGED_USERS table should be authorized to execute the above command.
Below is an example of the SQL statement that displays the GRANTEE on the PRIVILEGED_USERS table'
select cast(grantee/256 as INTEGER) as GroupID,
mod(grantee,256) as UserID
from NONSTOP_SQLMX_[system-name].SYSTEM_SECURITY_SCHEMA.PRIVILEGED_USERS;


The sample SQL Statement to check the UserID who is authorized to create SQLMX Catalog is as follows:
select cast(grantee/256 as INTEGER) as GroupID,
mod(grantee,256) as UserID
from NONSTOP_SQLMX_EXAMSVR.SYSTEM_SECURITY_SCHEMA.MGM_PRIVILEGES
where PRIVILEGE_TYPE = 'CC';

Note: [system-name] is the name of a logged-on system without a back-slash, e.g. if an MXCI session is running on \EXAMSVR, the [system-name] should be EXAMSVR.

    • Related Articles

    • SQLXpress - Error loading Environments - ERROR[1002] & ERROR[8822] after SQLXpress Installation

      This error means that MP Catalog, MX Catalog and MX Schema were either not created or registered on the respective node. The way to address this issue is for the customer to re-install SQLXPress on Node \XXXXX and create a SQLXPress catalog for MP ...

    • SQLXpress: How to recompile MX module

      The MX module can be recompiled manually by running the command 'RUN SETUPX MX COMPILE' from the installation subvolume. The SQLXpress must be stopped before recompiling the MX module and started after recompiling. e.g. TACL> SXSTOP TACL> RUN SETUPX ...

    • [EXTERNAL] SQLXPRESS on L25.09

      Known issues SQLXPress 3.80 on L25.09 against SQL/MX 4.0: Display of table properties and finding related objects for encrypted tables will fail with constraint errors due to the changes made to table metadata in supporting the new TDE functions in ...

    • SQLXPress: Does SQLXPress use MXCI?

      SQLXPress mainly uses dynamic SQL statements. However, SQLXPress does use MXCI for some of it's functions. Several background tasks, such as partition management and audit extract, include $MXCI in the scripts that they submit to NetBatch. Commands ...

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

      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. If the ...