Running the SharePoint 2010 IW Demo VM under Windows 8
Here is something that is very cool. Windows 8 includes Hyper-V, and it is super painless to run the SharePoint 2010 IW Demo VM under Windows 8:
Further, I was able to connect the wireless adapter to the VM, and activate Windows Server 2008 using WIFI. When using this VM under WS2008, it was necessary to physically connect a wire to the computer to do this activation, since there was no way to connect a WIFI adapter so that a VM could connect to the internet.
And, even while the VM is running you can sleep the computer!!!! How awesome is that! This capability alone makes Windows 8 worth the price of admission.
In a nutshell, here are the steps:
- Make sure that you have enabled hardware virtualization in your BIOS.
- Go to Control Panel, then go to Programs and Features
- Click ‘Turn Windows features on or off’
- Check the Hyper-V node in the tree control, let it install, and then reboot.
- Download and unpack the SharePoint 2010 IW Demo VM in the usual way. The remainder of these steps are basically identical to how you setup this VM when using Hyper-V under Windows Server 2008 R2 (with the minor exception that you can use WIFI to activate WS2008 in the VM).
- Using the Virtual Switch Manager in the Hyper-V Manager, add an internal network adapter (as detailed in Virtual Machine Setup Guide.docx). This guide is available on the same page as the rest of the IW Demo VM. This network should be called ‘Internal’. Set the IP4 address, per the instructions in the Virtual Machine Setup Guide.
- Import the Virtual Machine.
- Configure the memory and/or processors as necessary or desired.
- Boot the VM, and let it stabilize. It will add drivers and need to reboot. After rebooting, and letting the machine do all of its JITting, you can start IE and see SharePoint 2010 running.
- Shut down the VM.
- Using the Virtual Switch Manager in the Hyper-V Manager, add the WIFI network adapter.
- Edit the settings for the 2010-10a VM, and add the WIFI adapter to the Virtual Machine.
- Boot the machine. If you have WIFI connectivity, you will be able to browse the web from inside the VM.
- Click Start -> Right-Click Computer -> Properties. You can activate the VM from this dialog box. You now can use this VM without interruption for 180 days.
- Shut down the VM. Remove the WIFI adapter from the settings for the VM.
- Reboot, enjoy
stefano zanotti said,
June 28, 2012 @ 12:21 pm
Hello Eric White,
if I have formula in Excel Sum(A1:aA3) and I want insert whit SDK i a new Cell in position A2
There is a support in SDK to shift cells and update formula reference Sum(A1:aA3) to Sum(A1:aA4)
thanks
Eric White said,
June 28, 2012 @ 5:16 pm
Hi Stefano,
No, at this point there is no functionality to insert / delete rows or columns using the Open XML SDK. It is a non-trivial problem. You need to adjust all formulas. This means that you need to have a formula parser that can transform all formulas to abstract syntax trees. At this point, we recommend automating Excel to insert or delete rows or columns.
Note that it is significantly easier to insert or delete rows in tables in a workbook (with some caveats). For instance if there are two tables that are side-by-side in a worksheet, then it is much more difficult. However, if a table has no content to the right or left of it, then it is pretty straightforward to insert or delete rows.
-Eric
Stefano said,
June 29, 2012 @ 9:19 am
Hi Eric ,
in summary if I edit an Excel file with the sdk does not exist tools to manage the reorganization of the formulas.
Only using interop Excel reorganizes the formulas.
is that correct?
thanks
Stefano
PS. Italy vs. Germany 2-1 last night of European football
Eric White said,
June 29, 2012 @ 3:51 pm
Yes, that is correct.
-Eric
Ann B said,
November 26, 2012 @ 10:11 am
Hi Eric
Brilliant site, has helped immensely. Back in the dim and distant past you mentioned something about the Adventureworks content, any update on this? The people at http://mssalesdemos.com/DefaultAnonymous.aspx who now seem to have control of all the BCI demo files and are offering online labs, but it’s not the same as having your own to tinker with.
Thanks, again.