Use Data Source Configuration Wizard to change SQL Server user account

If the AssetCentre database has been moved or restored on a Microsoft SQL Server, it is important to reconnect the
FactoryTalk AssetCentre
 server to this new database. The following steps will walk through the
FactoryTalk AssetCentre
 Data Source Configuration Wizard, installed by default along with the
FactoryTalk AssetCentre
 server.
IMPORTANT:
The
FactoryTalk AssetCentre
 server and World Wide Web Publishing services should still be stopped at this point, following the restoration of the database. If this is not so, stop them now.
  1. From the
    FactoryTalk AssetCentre
     server computer, go to the
    Start
    menu and select
    FactoryTalk AssetCentre Data Source Configuration
    .
    Data Source Edit Wizard_Step 1 new
  2. Click
    Next
    on the first screen.
  3. Enter the name of the Microsoft SQL Server in the
    FactoryTalk AssetCentre SQL Server
     dropdown menu, and then click
    Next
    .
    Data Source Edit Wizard_Step 2 new
    IMPORTANT:
    • If you want to turn on the TLS for the database, the fully qualified domain name (FQDN) computer name is required when you specify the
      FactoryTalk AssetCentre
       SQL server.
    • The default port used for SQL Server communication is 1433. If you want to change the SQL Server port, you must add the port number after the FQDN SQL Server name. For example,
      mySQLServer.myDomain.com,1526
      . The comma (,) is required. You must ensure that the port is not in use by any other application, service, or process in your system.
  4. Configure the
    Account name
     and communication security options as needed, and then click
    Next
    .
    Data Source Edit Wizard_Step 3 new
    TIP:
    Microsoft SQL Server 2022, and later, support encrypted communication by enabling
    Force Encryption
     or
    Force Strict Encryption
    . When enabled, Microsoft SQL Server uses TLS (Transport Layer Security) to encrypt data transmitted between Microsoft SQL Server and clients, like the FactoryTalk AssetCentre server. The
    Force Strict Encryption
     option is not supported by FactoryTalk AssetCentre. The communications between FactoryTalk AssetCentre and Microsoft SQL Server can be encrypted by selecting the
    Encryption communication using TLS
     checkbox in this tool or enabling the Microsoft SQL Server
    Force Encryption
     option.
  5. Configure the
    FactoryTalk AssetCentre
     SQL Server Mirror properties if applicable, and then click
    Next
    .
    Data Source Edit Wizard_Step 4 new
    IMPORTANT:
    If the
    Enable SQL Mirroring
     checkbox is selected, in the
    FactoryTalk AssetCentre SQL Server Mirror
     box, you can enter a name of Mirror Database Server or SQL Server Mirror that hosts the mirrored
    FactoryTalk AssetCentre
     Database.
  6. Confirm the
    Database name
     and
    Connection Timeout
     values in the
    FactoryTalk AssetCentre
     SQL Server window, and then click
    Next
    .
    Data Source Edit Wizard_Step 5 new
  7. Click
    Finish
    , and a data source test window will appear.
    IMPORTANT:
    If the encryption key in FactoryTalk AssetCentre server does not match the one in the specified database, a dialog appears. Use the
    FactoryTalk AssetCentre Database Installer Utility
     to recover the encryption key and then apply your desired database changes. For more information, see
    If you receive an unmatched key error in FactoryTalk AssetCentre Data Source Configuration Wizard
     in the
    FactoryTalk AssetCentre Getting Results Guide
    .
  8. Press
    Test Data Source
     to test the connection that you’ve configured and verify that the test completes successfully.
    Data Source Edit Wizard_Step 6 new
  9. Click
    Done
    to close the wizard.
  10. Finally, start the
    FactoryTalk AssetCentre
     and World Wide Web Publishing services. From the
    Start
    menu, open the
    Services
    program. Start the World Wide Web Publishing service first Right-click on the World Wide Web Publishing listing and select
    Start
    .
    Data Source Edit Wizard_Step restart new
  11. Start the
    FactoryTalk AssetCentre
     Server service in the same way.
    The
    FactoryTalk AssetCentre
     Server is now connected to the newly restored database.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal