WCC Database Built in MS SQL Master Database

Document ID : KB000092621
Last Modified Date : 20/04/2018
Show Technical Document Details
Issue:
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.
Environment:
WCC 11.4 SP5 on Windows 
Resolution:
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.