What is the user name that we can create for accessing SQL database from WCC ( can it be “sa” (root)) so it has all the access on the database?
Chandru>> The user name can be anything of your choice; wcc, wccdbo, wccadmin, etc. While it is possible to use the sa user, I doubt your DBA would accept that. Please refer to the following KB on setting up WCC and WCC Reports databases on MS SQL Server.
How to move from Derby to MS-SQL database for CA Workload Control Center (CA WCC)
While the KB mainly talks about migrating from the default Derby database to MS SQL Server, the steps on DB creation would be similar.
This user which created for WCC is also the same when installing (scheduler and app server) when it prompts for DB Admin information, right?
Chandru>> WAAE installer needs a MS SQL user with database administrator role; SA user is the default admin. In case of MS SQL Server and Sybase, AE installer creates the autosys user and login.
What are the other 2 users (autosys, aedbadmin) created during installation of AE, how it different from “sa” (which has all the access on the database)?
Chandru>> autosys DB user is what AE by default uses for database operations. aedbadmin is applicable only in case of Oracle DB and this is used for maintenance. Sybase and MS SQL Server databases don't use aedbadmin user.
Cheers,
Chandru