Clarity Service Management

Expand all | Collapse all

Facing error after restoring CA SDM MDB database from MS SQL2008 r2 to MS SQL 2014

  • 1.  Facing error after restoring CA SDM MDB database from MS SQL2008 r2 to MS SQL 2014

    Posted 12-27-2018 01:09 PM

    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 .



  • 2.  Re: Facing error after restoring CA SDM MDB database from MS SQL2008 r2 to MS SQL 2014

    Posted 12-27-2018 02:06 PM

    After a restore you need to fix orphaned users.

     

    Exec sp_change_users_login 'AUTO_FIX', 'mdbadmin' 



  • 3.  Re: Facing error after restoring CA SDM MDB database from MS SQL2008 r2 to MS SQL 2014

    Posted 12-27-2018 02:42 PM

    Already applied this code also but still same thing.please suggest me what to do .



  • 4.  Re: Facing error after restoring CA SDM MDB database from MS SQL2008 r2 to MS SQL 2014

    Posted 12-27-2018 02:54 PM

    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?



  • 5.  Re: Facing error after restoring CA SDM MDB database from MS SQL2008 r2 to MS SQL 2014

    Posted 12-27-2018 03:02 PM

    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.



  • 6.  Re: Facing error after restoring CA SDM MDB database from MS SQL2008 r2 to MS SQL 2014

    Posted 12-27-2018 04:15 PM

    Yes I can log in into database properly but when I am trying to run pdm-configure I am facing the above issue.



  • 7.  Re: Facing error after restoring CA SDM MDB database from MS SQL2008 r2 to MS SQL 2014

    Posted 12-28-2018 04:30 AM

    Hi Siladitya,

     

    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?



  • 8.  Re: Facing error after restoring CA SDM MDB database from MS SQL2008 r2 to MS SQL 2014

    Posted 12-31-2018 02:14 AM

    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?

    Regards,

    James



  • 9.  Re: Facing error after restoring CA SDM MDB database from MS SQL2008 r2 to MS SQL 2014

    Posted 01-01-2019 08:57 PM

    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.

     

    Regards,

    Gordon.