4

I am not able to login into the Tridion 2013 sp1 as my SQL Server password is changed, even I updated the password in Tridion MMC but even then its not working.

So please some one suggest/guide me that where I need to update that password in Trdion, so that CME will able to connect again with SQL server?

Improve this question
7
  • Did you restart the COM+ application and Tridion services after making your change, if so, tried a reboot of the server?
    – Bart Koopman
    Commented Oct 9, 2014 at 8:01
  • @Bart: I restart the server many times, as well services.
    – Nash
    Commented Oct 9, 2014 at 8:02
  • The CM database password is stored in the MMC snap-in under Database settings, if you have changed that accordingly, then you should be good to go. If not it might help to edit your question and supply some more information.
    – Bart Koopman
    Commented Oct 9, 2014 at 8:19
  • Do you know which component can't connect? For some of the add-ons passwords are stored in a separate location
    – Andrey Marchuk
    Commented Oct 9, 2014 at 8:53
  • Are you able to connect and open your CM db from SQL Server management Studio using the credentials you entered in MMC.
    – Raj Kumar
    Commented Oct 9, 2014 at 10:14

3 Answers 3

Reset to default
5

As mentioned in the comments already, verify that you can connect to the database from Microsoft SQL Server Management Studio or from Visual Studio.

If you can't, review the user created in SQL Server. This video shows how to create a user in SQL Server, in your case, you should connect with the account "sa" and change the password for the existing user, but the video gives you an idea of how to access the users in SQL Server. If you are in a development environment, you can change the password of the CM user and after update the config to ensure both are the same.

http://www.youtube.com/watch?v=rbd1aOt8H94

If you don't have the credentials for connect with 'sa' account, double check with the DBA team and confirm that user/pwd is correct.

Improve this answer
3

Problem is resolved.

There is one more place where we need to change that password and that is Audience manager password along with database password in MMC.

So after changing the encripted password of Audience Manager, CME is start working fine.

Thanks

Improve this answer
0

I am not able to login into the Tridion 2013 sp1 as my SQL Server password is changed

is an assumption that the two problems are related; are you sure they are? What are the error messages in the event log (you should have many when Tridion cannot connect to the database)?

As comments/posts correctly state the Tridion CM components connect to the CM database using the configuration in Tridion.ContentManager.config (in the config subfolder of your Tridion installation) which is normally managed via the MMC snap-in (the database configuration is encrypted so you cannot directly edit it).

Without any additional information it is virtually impossible to troubleshoot this problem (could be as far fetched as the MMC updating the "wrong" Tridion.ContentManager.config file)...

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.