This section provides details on how to configure a database user that ScaleArc can use to communicate with the database servers assigned to the cluster. ScaleArc uses the configured access credentials, both during the initial cluster configuration process as well as during the continued operation of ScaleArc. ScaleArc performs the following tasks with the credentials:
- collect lists of databases, database users, and user privileges defined in the database server;
- monitor the health of individual database servers and that of the replication status between database servers assigned to the same cluster.
Follow these steps to configure Database Access:
- On the ScaleArc dashboard, click the CLUSTERS tab > Add Cluster button.
- Locate the Database Access section. This is the second panel on the Create Cluster screen.
Configure the fields as follows:
Field Description User input Username
Administrative user for the database server.
Refer to this KB article for more information on Minimum User Permissions Required for MSSQL Cluster.Note: Make sure you have super admin privileges to access database servers in order to configure this section. if you do not, contact your database system administrator for this information.
Enter the user name. Password Password for the above administrative user. Enter the password.
If you have joined Windows AD as a machine account, a pre-selected checkbox appears on top of the screen. Uncheck the box if you do not want the cluster configured for Kerberos.
Next, configure the Database Servers.