Error while creating a new database in SQL2005

Hello,

I am trying to create a new database through the SQL Server Management Studio and I am getting the following error:

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)

Kindly help to resolve this issue.

Thanks

Ramesh

Could you please post the whole stack ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Thanks Jens for replying.

I am copying the content shown under the show technical details button on that error dialog.

===================================

Cannot show requested dialog.

===================================

Cannot show requested dialog. (SqlMgmt)

Program Location:

at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.AllocateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider, CDataContainer dc)
at Microsoft.SqlServer.Management.SqlMgmt.DefaultLaunchFormHostedControlAllocator.Microsoft.SqlServer.Management.SqlMgmt.ILaunchFormHostedControlAllocator.CreateDialog(XmlDocument initializationXml, IServiceProvider dialogServiceProvider)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm.InitializeForm(XmlDocument doc, IServiceProvider provider, ISqlControlCollection control)
at Microsoft.SqlServer.Management.SqlMgmt.LaunchForm..ctor(XmlDocument doc, IServiceProvider provider)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ToolsMenuItem.OnCreateAndShowForm(IServiceProvider sp, XmlDocument doc)
at Microsoft.SqlServer.Management.SqlMgmt.RunningFormsTable.RunningFormsTableImpl.ThreadStarter.StartThread()

===================================

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

Program Location:

at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase.InitializeDataMembers(CDataContainer context)
at Microsoft.SqlServer.Management.SqlManagerUI.CreateDatabase..ctor(CDataContainer context)

I am not sure if you were looking for this. Please let me know if you need any further info.

Thanks again

Kind regards

Ramesh

|||If you believe its SSMS tools problem, try to reinstall them again. If it still doesn't work

Please file a bug on https://connect.microsoft.com/SQLServer/Feedback . Bugs filed on the connection center go straight into our defect tracking system. Since connection center bugs are filed by a customer, they have more weight than developer-filed bugs when it comes to deciding which bugs we'll fix next.

|||I received a similar error any time I try to "Modify" or "script" a stored proc from the SQL Server Management Studio. I can work around this by opening a query editor window and manually typing sp_helptext and the sp name. I did try reinstalling because I believed it to be related to some assemblies being accidentally deleted from the GAC, but no change on this error. Do you know of any assemblies that I should be looking for in the GAC and where to load them from if they're not there?

The actual msg I get is:
Method not found: 'Void Microsoft.SqlServer.Management.Smo.SqlSmoObject.Touch()'. (SQLEditors)

OR

Method not found: 'Void Microsoft.SqlServer.Management.Smo.ScriptingOptions.set_NoVardecimal(Boolean)'. (ObjectExplorer)

Thank you
-VG|||

I have received a similar error ,too. please install 'SQLServer2005SP2-KB921896-x86-EN.exe' or'SQLServer2005SP2-KB921896-x64-EN.exe'.it's OK!