Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

Can any shed any light on this one.


TITLE: Microsoft SQL Server Management Studio

Cannot show requested dialog.


Cannot show requested dialog. (SqlMgmt)

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



share|improve this question

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)

share|improve this answer

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
share|improve this answer
There was a massive difference in the files in the two locations, and i copied them over, but it didn't fix it. I'm not sure what service pack the files came from however. – optician May 8 '09 at 12:11
Can you try to re-apply the SP? – splattne May 8 '09 at 12:40

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

share|improve this answer

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.