Adding user and login for HA monitor

Create a special user and login for the monitor for each data server associated with the HAase resource. Use isql to connect to the data servers and issue:

sp_addlogin probe_ase, password

sp_adduser probe_ase

For example:

sp_addlogin joe, joe_password

sp_adduser joe

NoteDuring Adaptive Server configuration, the System Administrator should take into account that the user and login used for probe actually reduces by one the total number of connections available for other purposes.

For more information about storing the monitor login information, see “Creating an Adaptive Server login file”.