Users cannot log in or access the resources available on the Trados GroupShare 2020 server.

This KB article will provide the instructions on how to change the Microsoft SQL Server address used by Trados GroupShare 2020 in case you migrated the databases to a different SQL server.

NOTE!  Please be aware that you may forfeit the support covered in your SMA agreement if you migrate your GroupShare databases from one SQL server to another.

To avoid this, we highly recommend that the installation to be performed by our own experts, the RWS Professional Services or an RWS Authorised Reseller. If you wish to arrange an installation or request further information then please speak to your local RWS sales representative or an authorized reseller.

In the GroupShare Console the following changes need to be made:

1. Go to Console Root, Trados GroupShare 2020, Databases menu.
2. Change the values for the two Database Location fields to the new MS SQL Server address.
3. Click Apply Changes to confirm the changes as well as the restart of services.

In the GroupShare configuration files the following changes need to be made:

1. Open the configuration file Sdl.CustomPropertiesService.RestApi.dll.config with a text editor, e.g. Notepad++. Sdl.CustomPropertiesService.RestApi.dll.config is located in the Custom Properties Service folder of the Trados GroupShare installation location. C:\Program Files\SDL\SDL Server\Custom Properties Service\ .
2. Change the value for the attribute data source to the new MS SQL Server address in the following lines, and save the changes to the file:

<connectionStrings>
    <add name="systemDatabase" connectionString="data source=newsqlserverinstance;initial catalog=SDL_CPSService;integrated security=True;connect timeout=30" />
  </connectionStrings>

1. Open the configuration file Sdl.LanguageResourceService.Host.exe.config with a text editor, e.g. Notepad++. Sdl.LanguageResourceService.Host.exe.config is located in the LanguageResourceService folder of the Trados GroupShare installation location. C:\Program Files\SDL\SDL Server\LanguageResourceService\ .
2. Change the value for the attribute data source to the new MS SQL Server address in the following lines and  save the changes to the file:

<connectionStrings>
    <add name="systemDatabase" connectionString="data source=newsqlserverinstance;initial catalog=SDL_TMService;integrated security=True;connect timeout=30" />
  </connectionStrings>

 

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file Sdl.TMService.Agent.exe.config with a text editor. The Sdl.TMService.Agent.exe.config is located in the TMService folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\TMService\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and  save the changes to the file:

<connectionStrings>
    <add name="systemDatabase" connectionString="data source=newsqlserverinstance;initial catalog=SDL_TMService;integrated security=True;connect timeout=30" />
</connectionStrings>

 

<defaultContainerSettings hostName="newsqlserverinstance" containerNamePattern="TMContainer_{guid}" />

 

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file Sdl.TMService.Host.exe.config with a text editor. The Sdl.TMService.Host.exe.config is located in the TMService folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\TMService\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<connectionStrings>
    <add name="systemDatabase" connectionString="data source=newsqlserverinstance;initial catalog=SDL_TMService;integrated security=True;connect timeout=30" />
 </connectionStrings>

 

<defaultContainerSettings hostName="newsqlserverinstance" containerNamePattern="TMContainer_{guid}" />

 

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file Sdl.BcmService.Host.exe.config with a text editor. The Sdl.BcmService.Host.exe.config is located in the BCM Service folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\TMService\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

!!! Note: The BCM Service Host is no longer present with Trados GroupShare 2020 SR1 Cumulative Update 5.

1. Open the configuration file nlog.config with a text editor. The nlog.config is located in the Custom Properties Service folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\Custom Properties Service\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file Sdl.EditorService.Host.exe.config with a text editor. The Sdl.EditorService.Host.exe.config is located in the Editor Service folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\Editor Service\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file Sdl.EditorServiceRouter.Host.exe.config with a text editor. The Sdl.EditorServiceRouter.Host.exe.config is located in the Editor Service Router folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\Editor Service Router\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file: 

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file Sdl.FineGrainedAlignmentService.Agent.exe.config with a text editor. The Sdl.FineGrainedAlignmentService.Agent.exe.config is located in the FGAService folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\FGAService\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file nlog.config with a text editor. The nlog.config is located in the Notification Service folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\Notification Service\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=sqlserverinstance_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file nlog.config with a text editor. The nlog.config is located in the Reporting Service folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\Reporting Service\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file Sdl.StatisticsService.exe.config with a text editor. The Sdl.StatisticsService.exe.config is located in the Statistics Service folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\Statistics Service\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file nlog.config with a text editor. The nlog.config is located in the Translate And Analysis Service folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\Translate And Analysis Service\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:  

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file Sdl.TranslationModelService.Builder.exe.config with a text editor. The Sdl.TranslationModelService.Builder.exe.config is located in the TranslationModelService folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\TranslationModelService\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file: 

<connectionStrings>
    <add name="systemDatabase" connectionString="data source=newsqlserverinstance;initial catalog=SDL_TMModel;integrated security=True;connect timeout=30" />
 </connectionStrings>

1. Open the configuration file Sdl.TranslationModelService.Host.exe.config with a text editor. The Sdl.TranslationModelService.Host.exe.config is located in the TranslationModelService folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\TranslationModelService\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file: 

<connectionStrings>
    <add name="systemDatabase" connectionString="data source=newsqlserverinstance;initial catalog=SDL_TMModel;integrated security=True;connect timeout=30" />
 </connectionStrings>

1. Open the configuration file Sdl.Verification.Host.exe.config with a text editor. The Sdl.Verification.Host.exe.config is located in the Verification Service folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\Verification Service\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file: 

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file Sdl.GroupShare.WebHooksService.exe.config with a text editor. The Sdl.GroupShare.WebHooksService.exe.config is located in the WebHooks Service folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\WebHooks Service\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<connectionStrings>
    <add name="MS_SqlStoreConnectionString" connectionString="data source=newsqlserverinstance;initial catalog=SDL_WebHooks;integrated security=True;connect timeout=30" providerName="System.Data.SqlClient" />
  </connectionStrings>

1. Open the configuration file appsettings.json with a text editor. The appsettings.json is located in the Logging Service folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\Logging Service\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<connectionStrings>
"ConnectionStrings": {
    "log": "data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30"
  },

1. Open the configuration file appsettings.json file with a text editor. The appsettings.json is located in the Reporting Service folder of the Trados GroupShare installation location, full path by default is C:\Program Files\SDL\SDL Server\Reporting Service\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<connectionStrings>
"ConnectionStrings": {
    "log": "data source=newsqlserverinstance;initial catalog=sqlserverinstance_Logs;integrated security=True;connect timeout=30"
  },

1. Open the configuration file ApplicationService.exe.config with a text editor. The ApplicationService.exe.config is located in the Application folder of the Trados GroupShare installation location, full path by default is C:\Program Files (x86)\SDL\SDL Server\Application\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file ExecutionService.exe.config with a text editor. The ExecutionService.exe.config is located in the Application folder of the  Trados GroupShare installation location, full path by default is C:\Program Files (x86)\SDL\SDL Server\Application\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file Sdl.Core.FileprocessingService.FpsExe.exe.config with a text editor. Sdl.Core.FileprocessingService.FpsExe.exe.config is located in the File Processing Service folder of the Trados GroupShare installation location, full path by default is C:\Program Files (x86)\SDL\SDL Server\File Processing Service\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<target type="Database" name="database" connectionString="data source=newsqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

1. Open the configuration file Sdl.Core.FileprocessingService.FpsWindowsService.exe.config with a text editor. Sdl.Core.FileprocessingService.FpsWindowsService.exe.config is located in the File Processing Service folder of the Trados GroupShare installation location, full path by default is C:\Program Files (x86)\SDL\SDL Server\File Processing Service\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

<target type="Database" name="database" connectionString="data source=sqlserverinstance;initial catalog=SDL_Logs;integrated security=True;connect timeout=30">

!!! Note: The File Processing Service is no longer present starting with Trados GroupShare 2020 SR1 Cumulative Update 5.

1. Open the configuration file appsettings.json with a text editor. appsettings.json is located in the Management folder of the Trados GroupShare installation location, full path by default is C:\Program Files (x86)\SDL\SDL Server\Management\.
2. Change the values for each attribute data source to the new MS SQL Server address in the following lines and save the changes to the file:

"DefaultConnection": {
      "GsConnectionString": "data source=newsqlserverinstance;initial catalog=SDL_SDLSystem;integrated security=True;connect timeout=30;multipleactiveresultsets=true"
    }

In the  Trados GroupShare TMService database, the following changes need to be made:

1. Update the [ServerName] value in the TMService database table [dbo].[DatabaseServer] to the new address. By default the TMService database is named <TradosGroupShareSystemName>_TMService. You can review your actual TMService database name by opening the Sdl.TMService.Agent.exe.config, which is defined by the value for the initial catalog attribute of the line starting with <add name="systemDatabase" 

In the Trados GroupShare TM Model database, the following changes need to be made:

1. Update the [ServerName] value in the TMModel database table [dbo].[DatabaseServers] to the new address. By default the TMModel database is named <TradosGroupShareSystemName>_TMModel. Update the [ServerName] column with the new SQL database server name, like in the above TMService database change.
2. Update the IP Address column with the IP address of the new SQL database server.

Once all the changes are applied, follow the instructions from the article How to restart the SDL Trados GroupShare 2017/2020 Services in order to restart the Trados GroupShare Services.

The Trados GroupShare 2020 instance is not able to open its critical databases, due to a changed connection address of the relevant Microsoft SQL Server database infrastructure.

How to change the SQL server in a Trados GroupShare 2017 instance: https://gateway.sdl.com/apex/communityknowledge?articleName=000005433