The File Type Support (FTS) Server and encrypted communication with Microsoft SQL Server databases

If you added your certificate correctly to the Windows Certificates Store, the connection between the FTS Server and your SQL Server database should be successful by default.

Therefore, you do not need to make any additional settings for the FTS Server. Your Sdl.WorldServer.FileTypeSupport.Server.HostProcess.exe.config file should contain an entry such as the following:
<add name="SystemDb" connectionString="Server=<host>,<port>;Initial Catalog=<database-name>;User Id=<dbuser>;Password=<dbpassword>" providerName="System.Data.SqlClient"/>
In this case:
  • <host> is the fully qualified domain name of your database server
  • <port> is the port on which your database server is running
  • <database-name> is the name of your WorldServer database
  • <dbuser> is the username that you use to connect to your database
  • <dbpassword> is the password that you use to connect to your database