The Sysadmins

Tips and tricks from the Sysadmins

ADMT Series – Misc. Cannot open database ADMT – The login failed

If you install ADMT under a different user, you may receive this error when trying to access the ADMT MMC console:

Unable to check for failed actions. : DBManager.IManageDB.1 : Cannot open database "ADMT" requested by the login. The login failed.

To resolve this you will need to install the Microsoft SQL Server management Studio, download available here: http://www.microsoft.com/en-us/download/details.aspx?id=7593

Run the installer and select New SQL Server stand-alone installation or add feature to an existing installation.

Choose Add features to an existing instance of SQL Server 2008.

Select Management Tools – Basic (it’s greyed out here as I’ve already got them installed).

Follow the rest of the installation through, when complete run the SQL Server Management Studio and connect to the SQLEXPRESS instance.



Select Security, Logins and choose New login.

Add the account that needs access to the ADMT MMC Console and select Windows Authentication.

You can see the user added, right click and select properties.

Select User Mapping, tick ADMT and give the db_owner and public role membership.

The user will also need to be local administrator on the ADMT machine. You should now be able to open the MMC console.

3 Comments

  1. Works Perfect! Thanks Pal ! 2 days searching THIS solution!

  2. It should not be “Add features to existing SQL Server” but “Perform a new installation of SQL Server 2008”.
    But anyway – a great article. Thanks!

  3. In case anyone else has the same issues I did. I could not get the Managemnt Tools installed, as they did not even show as an option. I found an answer here:

    https://stackoverflow.com/questions/5834191/sql-server-management-studio-missing/11713463#11713463

    It states to install the Web Platform Installer (v4, but there on on v5). You can install from here:

    https://www.microsoft.com/web/downloads/platform.aspx

    Once that is installed you can install the “SQL Server Shared Management Objects”.

Leave a Reply

Your email address will not be published.

*