SQLAzureMW have a bug serious

Dec 13, 2011 at 8:38 AM
Edited Dec 13, 2011 at 8:45 AM

when I start SQLAzureMW.exe,and input imformation of service for Sql Azure,then,show"Index Out of Bounds",detail is:

"Microsoft.SqlServer.Management.Smo.SqlPropertyMetadataProvider.PropertyNameToIDLookupWithException(String propertyName, PropertyAccessPurpose pap".

I'll crazy,What hell is this?



My Environment as this:

 SQL Server Management Studio is V10.50.2500.0

 SQLAzureMW is SQLAzureMW v3.7.8 Release Binary

 sql azure is V11.0.1814

Dec 13, 2011 at 11:39 AM




In July, SQL Azure upgraded the servers (for more info see: http://blogs.msdn.com/b/windowsazure/archive/2011/07/13/announcing-sql-azure-july-2011-service-release.aspx). These changes require that any program using SMO run on SQL Server 2008 R2 SP1. So, you need to download SP1 and you should be ok. You can download SQL Server 2008 R2 SP1 here: http://www.microsoft.com/download/en/details.aspx?id=26727


If you still have issues after installing SP1, let me know.





Jan 13, 2012 at 8:22 PM


I was getting the same error when trying to update an existing database using 2008 R2.  As a work around, I was able to give the tool a new DB name and everything started to work.