Our WCC Server database was built on MS SQL Server. After the installation we noticed that the WCC database was built in the Master database.
When you install WCC with Derby Internal Database, the database is created automatically by the installation procedure.
But when you install WCC with an External database like MS SQL Server, you will need to create the database manually in MS SQL Server prior to WCC installation.
The database and database users will need to be created by the database administrator.
Database users must have Connect, Create/alter table, Create/Drop Index and Create Sequence permissions for the database.
External Microsoft SQL database instance specified during WCC installation must be configured for standard user authentication. Windows user authentication is not supported by WCC.