Before You Begin Installation of SQL Server
• The installing user (typically the database administrator [DBA]) must be a member of the Windows Administrator group.
• You must have 1.5 GB available hard drive disk space for a SQL Server installation with a Windchill demo database. More disk space is needed for larger databases.
• For additional installation requirements and platform prerequisites, consult the Microsoft SQL Server documentation, or visit:
Note the following:
• Database installation must be configured with mixed mode authentication.
• Database instance must be have 'contained database authentication' configuration option activated. It can be activated by executing following statements as database admin user sa:
use master
GO
sp_configure 'contained database authentication', 1;
GO
RECONFIGURE
GO
• Windchill database must have the following required filegroups:
◦ PRIMARY
◦ BLOBS
◦ INDX
◦ WCAUDIT
• SQL Server database user should be created as contained DB user.
• Database schema name and schema owner user must be identified by same name.
• Default schema for database user must be identified by same name.
• Windchill database must be configured as partially contained. It can be set using following statement as database admin user sa:
ALTER DATABASE [<database_name>] SET CONTAINMENT = PARTIAL WITH NO_WAIT;
• Windchill database must have read_committed_snapshot property set. It can be activated using following statement as database admin user sa:
ALTER DATABASE <database_name> SET READ_COMMITTED_SNAPSHOT ON
• The Windchill SQL Server database user should be created as contained DB user:
◦ User Type: SQL User without login
◦ Database User name, Schema name, Schema owner, and Default schema must be identified by same name
• Windchill Database user must be a member of the db_owner role.
• For a new Windchill 11.0+ installation with SQL Server 2012 and later releases, the Windchill application database collation (Latin1_General_100_CS_AS_SC) and SQL Server instance level collation can be different where the contained database instance is properly configured.
• If you are planning to upgrade Windchill on SQL Server 2008 R2 or earlier versions to SQL Server 2012 or later versions then the upgrade needs to be completed with SQL Server 2008 supported collation SQL_Latin1_General_CP1_CS_AS. After upgrade the database Collation should be changed to SQL Server 2012 and later supported collation Latin1_General_100_CS_AS_SC using Collation Conversion Utility from upgraded version.
◦ Updating with a new sub installer for an updated server is allowed with Server 2014 (SQL_Latin1_General_CP1_CI_AS (UCS-2)) .
◦ Database schema name and schema owner must be identified by same name.
◦ SQL Server user, and schema must be identified by same name.
◦ Default schema for database user must be identified by same name.
|
|
Do not grant DBA or Database Admin roles or privileges to Windchill database users.
|
Windchill Business Reporting
The following are the supported Microsoft SQL Server database platforms and collations for Windchill Business Reporting:
• Windchill Business Reporting database: Latin1_General_100_CI_AS
• Windchill database: Latin1_General_100_CS_AS_SC
