Sign in or 
Location: Hyperion Financial Management
Discussion: Disaster Recovery Scenario
Category:
Discussion Forum /
General Discussion
Share this
Showing 3 posts
jbozich |
Disaster Recovery Scenario
Mar 9 2009, 2:27 PM EDT
Hello All:Does anyone know the appropriate steps for restoring the backups from one environment to another? Without going into great detail, here is the scenario....we have an HFM 9.3.1.1 Production environment with SQL backend....I've tried to take the sql backups from PROD and restore them into our QA environment but can't get the QA environment to work afterward. I've gone through the config wizards on the different QA servers and had to manually tweak some of the sql security....but it still won't work properly.....I am unable to log into workspace.....keeps telling me I need valid username/pwd for system....like there is some disconnect between workspace and shared services.... Anyway, if anyone sees any glaring aspect I've overlooked, please advise....thanks! Jim Do you find this valuable?
Keyword tags:
Disaster Recovery
HFM
Hyperion
System 9
|
|
kmugundh |
1. RE: Disaster Recovery Scenario
Mar 13 2009, 3:28 PM EDT
Please try the following ( i am assuming you are using MS SQl server as your DB)USE DBNAME go EXEC sp_change_users_login 'Update_One', 'LoginUserid', 'LoginUserid' Note: if you are using a different SQl login userid then this 'Login Userid' ,'NewloginUserid' Do you find this valuable? |
|
jbozich |
2. RE: Disaster Recovery Scenario
Mar 13 2009, 4:08 PM EDT
Thanks for the suggestion.I manually reconfigurerd all of the SQL accounts....I don't think that is the hitch....what's happening is that I can't log into workspace after restoring db's from our PROD into QA environment.....workspace doesn't recognize any userid I try...even the native admin account we created. Ideas? Do you find this valuable? |
