Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
add comment

5 Answers 5

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
add comment

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
add comment

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
add comment

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

share|improve this answer
add comment

Your Answer

 
discard

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.