Error: MissingMethodException

Apr 9, 2010 at 5:13 PM

http://sqlazuremw.codeplex.com/WorkItem/View.aspx?WorkItemId=4339

I am getting the following error after connection to SQL 2008 Database:

System.MissingMethodException: Method not found: 'Microsoft.SqlServer.Management.Common.DatabaseEngineType Microsoft.SqlServer.Management.Smo.Server.get_ServerType()'.

It appears that I am not the only one:
http://social.msdn.microsoft.com/Forums/en/sqltools/thread/9653aa25-3c7c-429c-845a-e1dfa0b747ba

Any clues as how this can be resolved?

Apr 9, 2010 at 5:33 PM

http://sqlazuremw.codeplex.com/

Requirements
SQLAzureMW requires SQL Server 2008 R2 bits to run.

Apr 9, 2010 at 6:51 PM

Installing SQL Server 2008 R2 Management Objects did not help.

Still getting same error:

System.MissingMethodException: Method not found: 'Microsoft.SqlServer.Management.Common.DatabaseEngineType Microsoft.SqlServer.Management.Smo.Server.get_ServerType()'.

Coordinator
Apr 10, 2010 at 10:46 PM

Hi,

get_ServerType is a new method with SQL Server 2008 R2 bits.  Let’s compare assemblies.  Mine is located at: C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies file name Microsoft.SqlServer.Smo.dll.  Under properties/Details, it says file version 10.50.1376.2, size 2.9 MB and date modified 12/27/2009.  Is yours the same?

Regards,
George