After restore CA MDB SQL Server 2008R2 backup on SQL Server 2014,While run pdm_configure on database part it showing below error
But if I choose Load Default data it is working fine please suggest .
After a restore you need to fix orphaned users.
Exec sp_change_users_login 'AUTO_FIX', 'mdbadmin'
Already applied this code also but still same thing.please suggest me what to do .
Are you able to log onto the database with SQL Server Management Studio with those credentials?
Can you access the MDB when loggedin with those credentials?
If yes, what does the log says?
You may need to edit entries in usp_servers table too.
And to avoid those kind of problems, i always backup configurations tables and restore them after the DB is restored.
Yes I can log in into database properly but when I am trying to run pdm-configure I am facing the above issue.
What is the account that is configured for MDB communication? Could you confirm if this account is part of Administrator and also part of Administrator Group on the server?
You might find this thread Cannot connect to mdb database - pdm_confgure useful.
Can you log on to the MDB from the SDM host as mdbadmin using SQLCMD?
The configure.log in NX_ROOT\log is the first place to check. You can also run 'pdm_configure -z' which will write more debug info to the configure.log.
Retrieving data ...