Home / server / Questions / 6226
In Process
optician
Asked: 2009-05-09 03:11:54 +0800 CST

Error when trying to view properties in Management Studio

  • 772

I am having trouble with sql manager after install SQL 2005 SP3,

Can any shed any light on this one.

Thanks

TITLE: Microsoft SQL Server Management Studio

Cannot show requested dialog.

ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

Method not found: 'Microsoft.SqlServer.Management.Smo.Edition Microsoft.SqlServer.Management.Smo.Information.get_EngineEdition()'. (SqlManagerUI)

BUTTONS:

OK

sql-server-2005 ssms database

5 Answers

    • 1

  2. If it was a databases's properties you were trying to look at, check the owner of the database you are trying to look at. It might be orphaned - you can use

    EXEC sp_changedbowner 'sa'

    and see if that helps (doesn't have to be sa - whatever the appropriate account is)

    • 1

  3. There could be some missing SQL Server SMO assembly files. To solve this, just follow this procedure:

    1. Look for an installation which works fine
    2. Copy all files from C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies folder and paste it in C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies of the machine with the corrupted installation.
    3. Don't overwrite any file. Just copy the missing files
    • 0

  4. Is it possible that you applied the service pack to a different instance than the one to which you are attempting to connect?

    • 0

  5. If you don't have enough privileges to see that dialog, SSME will throw that error. Check your users privileges.

    • 0