Failure when sending tracking definitions

Installing a snapshot from IBM® Process Center to IBM Process Server is successful, however there are errors in SystemOut.log (CWLLG2229E and sql error com.microsoft.sqlserver.jdbc.SQLServerException: The specified schema name "sa" either does not exist or you do not have permission to use it). Tracking definitions are not sent successfully.

In Microsoft SQL Server, the default schema name associated with a user must be the same as the user name. For example, if the Performance Data Warehouse database user name is perfDB then the default schema name associated with the user perfDB must also be named perfDB. When the Performance Data Warehouse database user name is sa, the default schema name is required to besa. However, sa is a super user in Microsoft SQL server, and the default schema for the super user is dbo and this schema name cannot be changed.

You must create an ordinary database user and assign the required rights to the user instead of using a super user, such as sa.

To recover from this situation, fix the Performance Data Warehouse data source to work properly on SQL Server by following these steps:

On the Process Server network deployment environment, change the Performance Data Warehouse data source to use the Performance Data Warehouse user name perfDB instead of the username sa .
Stop the Process Server deployment environment.
Drop the Process Server Performance Data Warehouse database on SQL Server.
Using db scripts, recreate the Performance Data Warehouse database with the user perfDB instead of the user sa.
The Performance Data Warehouse tables in the database are created under the user schema perfDB.
Restart the Process Server deployment environment.
In the Process Admin console, run Update tracking definitions for each process application that is deployed. This may take some time to complete.