You cannot specify a user name and password with the MQ endpoint as you can using JMS. All connections to the MQ queue manager are made as the user that the Adaptive Server process is running as. After making the connection to the MQ queue manager, Adaptive Server then attempts to open the queue as the Adaptive Server login that is performing the operation. For this reason, the user must:
Have a user account on the machine on which the MQ queue manager is running. Without such an account, the user must use the msgsend function’s alter_user=yes option to perform messaging operations. See Table 3-11 in the msgsend reference pages.
Have the MQ authorizations listed in Table 2-2.
The Adaptive Server messaging_role is
still required to execute Real Time Data Services built-in
functions.
In addition, the ‘register, login' and 'default, login' functions of sp_msgadmin do not allow you to register Adaptive Server logins, or to create default Adaptive Server logins if the endpoint specified is a queue manager. See sp_msgadmin.