Can not connect to MDE Database

After Restore MDE Backup into Migration Server it may show the error message as cannot connect to MDE Database.

Solution

  • Download attached Tool from PoTools.(MDE Dcl Fix included.)
  • Enter Login Credentials of SQL Server in this Tool.
  • Execute the Tool using "Auto Fix for DCL " Button.
DCL User Auto Fix will Fix for BPRO, BPLOG, POST,SIGN, PROJECT, SOSB, NREGAEMO, MDE and MDE_SIGN databases.

Download


Download

Solution : Method 2

Fix MDE Login Issues using DB Analyzer ( Thanks to Rajesh H)

Follow these steps
1. Open management studio. Right click on mde database. Rename as offline.
2. Open DB analyzer > DB utilities > Update to SQL 2005. Select database offline and update.
3. Re name offline database as MDE management studio.

Do same steps for mde_sign also.