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!

|||

I have the following OS installed: Windows Server 2003 - SP2

I have installed SQL Server 2005 with SP2.

But still I'm not able to fix the error and I'm not able to create a New Database using the SQL Management Studio. I'm not even able to run queries in the Qiery Window to create the Database.

How can this problem be fixed?

Is there any hotfix available?