Announcements
Hello:
Our DBA changed the "sa" password. Now, the Management Reporter Configuration Console will not open.
What do we do?
John
*This post is locked for comments
Chances are when MR was installed SQL credentials were used to setup the databases. You will have to have your IT staff set the 'sa' password back to what it was so you can get into the MTR configuration program and then setup MR and the data mart to use Windows credentials. We normally create a separate domain account just for MR for just this reason. Once MR is reconfigured with this new account they can set the 'sa' password to whatever they want. Do you have access to those who installed MR? They will need to configure the connections to not to use SQL credentials.
I was the one who did the install. I read this morning on another Community page that, when the "sa" password is changed, you just simply open up the Configuration Console and change the "sa" credentials. But, I can't get into MR to do this. And, our DBAs won't change the password back.
So, it looks like the app is closed forever and I'm out of a job. Terrific!
What message are you getting when you try and open the Config Console? I just changed my sa password in a sandbox I have and I can still get in and update the password. I used the sa password for initial set up as well. Could the credentials for the MR service account have been changed as well?
It's a simple message, Matt, saying the Configuration Console has stopped working. I don't know what else to share on this.
I also wish that this Forum allowed me to edit the title of my posting. I misspelled "Configuration" in my haste to get this post up, and I look even more like an idiot.
Have you attempted to restart the two Management Reporter services manually? You can get to them like other services under the Administrative Tools in Windows.
Yes, I had already done that. No dice.
John, you made a simple ID 10 T error. Our clients do this all the time. As resellers we never make any mistakes(if you believe that I have some swampland down in Louisiana for you). As I said before you need to get your IT team and your partner involved here. I am sure you have reports you want to generate and there is only so much we can do in this forum. I offer my services but I will defer to your partner and give them first dibs.
I got past the issue by uninstalling and reinstalling MR server components. Now, when I try to create the application and process services again, I get this message: Connection string must use Windows Authentication when verifying a connection under impersonation. Parameter name ConnectionString. Any ideas?
Read through this previous thread.
community.dynamics.com/.../36295
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Dan Liebl 2
