Because system configurations, database software, and individual company standards vary, use this section as a checklist instead of step-by-step instructions for Microsoft SQL Server 2019 running on a Windows Server 2019 operating system. Please contact Customer Support for specific configuration questions.
If you are using a Global Workshare Configuration, you must install the Enterprise Edition of Microsoft SQL Server for your Host and Satellite locations.
-
There are internationalization considerations concerning the SQL Server collation settings you specify that relate to reference data, using SmartPlant Enterprise integrated systems, Global Workshare Configuration, multiple locales, backup/restore, reports, and upgrading to future releases. Please contact Customer Support for specific configuration questions.
-
See Initialize the Microsoft SQL Database with Minimum Access Privilege if you want to minimize user access privilege to the database.