Comprehensive data protection for all workloads
Post Reply
vipthomps
Service Provider
Posts: 45
Liked: 3 times
Joined: Dec 06, 2010 7:51 pm
Full Name: Eric Thompson
Location: Boston, MA
Contact:

Change the Remote SQL User password for Enterprise Manager?

Post by vipthomps » Dec 06, 2016 9:44 pm

Hi all.

I've opened a support case for this but not getting too far yet. WIth Ent. Mgr 9.5 on a 2016 box i had it connected to a remote SQL instance. That was fine. For an unrelated reason I rolled the password of that SQL user and changed it on the backup and replication server with no issues using the Configuration tool that VB&R installs.

However that utility doesn't exist with just Enterprise Manager and it appears the only spot for the SQL user password is in the registry key and thats hashed/encrypted? Anyone figure out how to do this in any version? I've seen forum posts on how to change the user, the DB, the server but NOT the password. I can't even uninstall EM as that just fails and the logs aren't very helpful. I'd rather not delete the EM virtual machine but i'm pretty close to out of options.

Thanks!

foggy
Veeam Software
Posts: 17931
Liked: 1512 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Change the Remote SQL User password for Enterprise Manag

Post by foggy » Dec 07, 2016 4:30 pm

Hi Eric, not sure if it helps, but you could stop EM service and then try to uninstall it.

vipthomps
Service Provider
Posts: 45
Liked: 3 times
Joined: Dec 06, 2010 7:51 pm
Full Name: Eric Thompson
Location: Boston, MA
Contact:

Re: Change the Remote SQL User password for Enterprise Manag

Post by vipthomps » Dec 07, 2016 4:56 pm

Thanks Foggy. No luck though. Actually service won't even start since it can't get to the database.. I have a support call in 5 minutes so we'll see what we come up with

vipthomps
Service Provider
Posts: 45
Liked: 3 times
Joined: Dec 06, 2010 7:51 pm
Full Name: Eric Thompson
Location: Boston, MA
Contact:

Re: Change the Remote SQL User password for Enterprise Manag

Post by vipthomps » Dec 07, 2016 5:29 pm 1 person likes this post

So we came up with a fix. We deleted the values in the registry keys SqlSecuredPassword and SqlLogin then we changed the Ent. Mgr service from Local System to a domain account and gave that account db_owner on the database on the remote sql box as well as sysadmin (was only required for the first start of the service then I removed that role)

We were able to then get the service up and running. At this point we need to leave it as an AD account since there is no way to change the SQL user password for Enterprise Manager on a standalone server (IE not on the same server as VB&R) short of an uninstall/reinstall so I'd file that under a feature request.

foggy
Veeam Software
Posts: 17931
Liked: 1512 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Change the Remote SQL User password for Enterprise Manag

Post by foggy » Dec 07, 2016 5:32 pm

Thanks, Eric. Request is accepted.

Post Reply

Who is online

Users browsing this forum: BassTeQ, dejan.ilic@liu.se, Google [Bot], opetit and 44 guests