Database Considerations

Microsoft SQL (MSSQL) Server is a required component for any FactoryTalk AssetCentre implementation. While it is not required to be installed on the same host as any FactoryTalk AssetCentre component, many architectures have it co-located on the same host as the FactoryTalk AssetCentre server. FactoryTalk AssetCentre supports Express, Standard, and Enterprise editions.

An existing MSSQL server might be used for FactoryTalk AssetCentre, and the server does not need to be dedicated to FactoryTalk AssetCentre alone. In other words, it can hold databases for multiple applications. If a new installation will be used, refer to the steps described in the "Installing Microsoft SQL Server" sections of the FactoryTalk AssetCentre Installation Guide.

When the FactoryTalk AssetCentre server is installed, the AssetCentre database is created in the chosen MSSQL server. In addition to the database, the AssetCentreUser SQL user and AssetCentreUser schema are created. The database creation is an on-installation only event, meaning that the desired MSSQL server should be identified prior to AssetCentre server installation. Note that remote connections to the server must be enabled for the installation of the FactoryTalk AssetCentre database.