When launching Client Maintenance, users must provide credentials to show they have permission to make administrative changes to the database. On the login screen, the user must supply the locations of the Lucity Config folder and the agency's license file, as well as some database system administrator credentials.
How To Log into Client Maintenance
When the installer launches Client Maintenance or a user launches it as a stand-alone product, the following window appears:
In the Config Folder field, specify the path to the Lucity Config folder.
In the License File field, specify the path to the provided license file.
Enter the the Admin DB Login ID and the Admin DB Password. If multiple SQL Server/Oracle installations exist, with different credentials for each, enter the credentials for one of the installations. The system will prompt for the others later.
This user is typically a user in the SQL Server SYSADMIN role. This role has the permissions typically required by Client Maintenance.
ALTER ANY LOGIN - Used to create/update SQL Server logins that Lucity applications use to connect to the database. Typically named Lucity_User and Lucity_Gateway.
DB_OWNER role for the Lucity Database - Used to perform various such as creating users, schemas, roles, tables, views, stored procedures, triggers, indexes, changing db compatilbilty level, checking for backups, checking files sizes, etc....
If the user is not in the SYSADMIN role you will recieve a message letting you know that it will attempt to run but may not have all necessary permissions. If the program attempts to perform a function that it does not have permission to perform it will display a warning message.
Check the Use Windows NT Integrated Security checkbox if you wish to connect to the database servers via Windows Authentication and the database servers have already been properly configured.
Click Next. The utility begins updating the Lucity configuration information.
