Install SQL Server 2012 Web edition on Azure (2VM script)

Hi!

Since I'm a newbie on installing stuff on Azure I would like to share my experiences.

I was going to do a installation with the 2VM script (http://msdn.microsoft.com/en-us/library/dn168972(v=nav.70).aspx) but ended up with some problems with the SQL Server 2012 Web edition image.

If you look at the SQL images you can use on azure (http://msdn.microsoft.com/en-us/library ... aspx#about) Web edition image of SQL 2012 only exists with OS Windows Server 2008.

What I discovered is that Windows Server 2008 doesn't have the right version of powershell to fully succeed with the 2VM script.
Instead you will get the errors:

VERBOSE: Loading module from path 'C:\REMOTE\NAVAdministration\Microsoft.Dynamics.Nav.Management.dll'.
Could not load file or assembly 'file:///C:\REMOTE\NAVAdministration\Microsoft.Dynamics.Nav.Management.dll' or one of its dependencies. This assembly i
s built by a runtime newer than the currently loaded runtime and cannot be loaded.
+ CategoryInfo : NotSpecified: (:) [Import-Module], BadImageFormatException
+ FullyQualifiedErrorId : System.BadImageFormatException,Microsoft.PowerShell.Commands.ImportModuleCommand
+ PSComputerName : processpumpsql.cloudapp.net


and

VERBOSE: Creating database DynamicsNAV71 based on C:\Install\Database\Demo Database NAV (7-1).bak...
The term 'New-NAVDatabase' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if
a path was included, verify that the path is correct and try again.
+ CategoryInfo : ObjectNotFound: (New-NAVDatabase:String) [], CommandNotFoundException
+ FullyQualifiedErrorId : CommandNotFoundException
+ PSComputerName : processpumpsql.cloudapp.net


So what to do then?

Well, the major steps are to execute the 2VM script up to the point where it needs the new powershell version, then install the new powershell version. After that execute the rest of the 2VM script.

In detail, first start Windows PowerShell ISE, run the entire script (F5) and break (CTRL+C in the console) when all the librarys has been loaded.
Then mark all the code up to the section HowTo-AddNAVInstance, that is the failing part. Press F8.

Once the script is finnished, connect to the SQL VM and follow this guide http://technet.microsoft.com/en-us/library/hh847837.aspx#BKMK_InstallingOnWindowsServer2008LH

After that mark the rest of code in the 2VM script and execute (F8) and it should work.