Target System SQL Database Considerations
• Configure SQL Server Database to Contained Database Authentication
• Database Collation
Configure SQL Server Database to Contained Database Authentication
The SQL Server database instance on the host where you are installing the target Windchill application must be configured to use ‘contained database authentication.’ Execute the following statement on the SQL Server database instance:
use master
GO
sp_configure 'contained database authentication', 1;
GO
RECONFIGURE
GO
Database Collation
When upgrading from a Windchill 11.0+ release, the target SQL Server database instance needs to be installed with collation Latin1_General_100_CS_AS_SC.