5

I have set up SDL Web8 (CMS, CD) on two different machine in following way.

I have Server0[for databases], Server1[Setup 1#] and Server2[Setup 2#].

[Setup 1#]

  • Created databases for “cm”, “topology”, “broker”, and “experience” in Server0 for both Server1 and Server2.
  • Installed SDL Web8 CMS, Content Delivery on Server1 using databases created in Server0.
  • Publishing is working fine to broker1, webapplication1 is running fine in Server1.
  • Everything is working amazing.

[Setup 2#]

  • Then created Server2 by cloning Server1 machine.
  • Created separate set of databases again for “cm”, “topology”, “broker”, and “experience” in Server0.
  • CMS and Content Delivery in cloned in Server2, are customized to use these newly created set of databases in Server0.
  • Publishing is working fine to broker2, Webapplication2 is running in Server2.

I realized both Server1 and Server2 are using same topology Manager Database but working fine. But in future PowerShell command for 1 may impact other as well.

I am not able to figure out a way to change the topology database. Please suggest a way to change the Database for one of these? Thanks.

6

Please re-point the topology manager database to another database [Setup#2].

  1. Navigate to server 2 %Tridion_Home%\TopologyManager\web
  2. Decrypt server 2 database section in web.config
  3. Change database settings in node in web.config
  4. Encrypt the config file
  5. Restart IIS [Server #2]

For more information click here and see below - How to Decrypt a web.config File

Copy the config file in temporary directory.

To decrypt the configuration file, start with making a temporary directory somewhere to put the Tridion.ContentManager.config file. For this example we'll use c:\temporary .

For decrypt the webconfig parts :

c:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -pdf "database" c:\temporary 

After entering this command, the database section in the config is decrypted and unprotected. So you need to encrypt again by running below command:

c:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_regiis.exe -pef "database" c:\temporary -prov "TridionRsaProtectedConfigurationProvider"

Once done all place the file in below location:

%Tridion_Home%\TopologyManager\web
  • Yeah this worked on my local test environment. Hopefully it would work on "Server2".. Thanks a lot. – Javed Khan Oct 24 '16 at 9:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.