Cannot Connect to MDE Database : DCL User issues Revised

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 .(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 

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.