2

For existing Tridion (2013 SP1) CMS installation is there any configuration file under the installation directory that stores the underlying database details for CMS like we have cd_storage_conf.xml in Deployer that stores the database details for published content?

Somehow the Tridion MMC Console is not working that is one option to figure out the DB configured for CMS server.

Improve this question

2 Answers 2

Reset to default
4

Tridion.ContentManager.Config contains this information.

The database info is encrypted, follow the steps outlined here to read it.

From the linked article:

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:\temp. From a new command prompt:

mkdir c:\temp

Copy the Tridion.ContentManager.config file to this directory and rename this file to web.config. Remember that the tool (aspnet_regiis.exe) was designed for web applications, so this is the reason why this step is necessary.

copy c:\tridion_install_dir\config\Tridion.ContentManager.config c:\temp\web.config

Now it's time to decrypt the parts that are encrypted in this config file.

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

Improve this answer
6
  • Thanks Nuno for sharing same; I got error while decryption and it seems if we use <database configProtectionProvider="TridionRsaProtectedConfigurationProvider"> in config file it will fail. Error Message - "Failed to decrypt using provider 'TridionRsaProtectedConfigurationProvider'. Error message from the provider: The RSA key container could not be opened."
    – Gulshan Thakur
    Commented May 22, 2017 at 21:29
  • 1
    Your user doesn't have permissions to read the content. Use the account used to install Tridion, or the mtsuser account
    – Nuno Linhares ♦
    Commented May 22, 2017 at 21:59
  • To use the {domain}/MTSUser i need to reset the password for this domain user; is it ok to do this ? the fear is if tridion store MTSUser credentials encrypted in some conf files then reset password may break the things.
    – Gulshan Thakur
    Commented May 23, 2017 at 15:46
  • Yeah, stuff will break if you change that password. Top of my head, any COM+ related code (if you have any) and Search will stop working.
    – Nuno Linhares ♦
    Commented May 23, 2017 at 16:29
  • Thanks Nuno for the confirmation; it helps to avoid creating new issues. I have raised separate thread to discuss more on this MTSUser issue tridion.stackexchange.com/questions/17161/…
    – Gulshan Thakur
    Commented May 24, 2017 at 16:35
2

The Tridion console is locked to specific users. The user who installed Tridion will have to give permissions to all other users, which can be an issue if the installer is not on the project.

A way around this is the following.

Download psexec.exe from https://technet.microsoft.com/en-gb/sysinternals/bb897553.aspx?f=255&MSPPError=-2147217396

Open a command prompt in Admin view and navigate to the folder the psexec.exe is in

run the command psexec -h cmd (This will elevate the users token)

navigate to C:\Windows\Microsoft.NET\Framework64\v4.0.30319 (Or whatever the .NET framework is)

Run the command aspnet_regiis -pa "TridionRsaKeyContainer" "<domain>\<account>" (Where domain and user is updated to udm000\user.name

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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