Posts Tagged ‘2008’

Installing the .NET Framework 4.0 on your Windows Server 2008 R2 x64 server with SharePoint 2010

Written by Cornelius J. van Dyk on . Posted in Blog

As we all know, SharePoint 2010 is still using the .NET Framework 3.5.  That means that your servers may not have the latest .NET Framework 4.0 installed.  This could cause some issues if you’re trying to use APIs from 4.0, or if you are trying to build some new tools using 4.0, like PowerShell management extensions for example.  The solution is to install 4.0 on your server.  Here’s the quick Step-by-Step for doing this on a Windows Server 2008 R2 x64 system with SharePoint 2010 installed.

  1. Begin by downloading the full version of the Framework from here:
  2. Once downloaded, double click the installer file named “dotnetFx40_Full_x86_x64.exe”.

  3. Windows may require you to confirm that you wish to launch the EXE.  If it does, simply click “Run”.

  4. You’d have to accept the EULA.  Check the “I have read and accept the license terms” check box.
  5. Click the “Install” button to commence the installation.

  6. The installer will crunch away for a while as it installs the Framework.

  7. Once installation complete, click the “Finish” button.

  8. No server restart is needed. 🙂



How do I – Move my SharePoint databases from a 32 bit Windows Server 2003 x86 with SQL Server 2005 x86 to a new SQL instance on a 64 bit Windows Server 2008 R2 x64 with SQL Server 2008 R2 x64

Written by Cornelius J. van Dyk on . Posted in How Do I...

As part the migration plan for a major customer of mine, we had a phase scheduled to move the back end databases from 32 bit Windows Server 2003/SQL Server 2005 to 64 bit Windows Server 2008 R2/SQL Server 2008 R2.  This brought back to light the question of how to move your content to a new SQL Server.  There are many good articles out there, but this worked well for us.—Move-my-SharePoint-databases-from-32-bit-SQL-Server-2005-x86-to-a-new-Instance-on-64-bit-SQL-Server-2008-R2-x64.aspx



How do I – Get a list of all databases attached to my SQL Server 2008 R2 database server

Written by Cornelius J. van Dyk on . Posted in How Do I...

Another quick one… You can run this stored procedure:

exec sp_databases

Which should yield the following output:


or you could try this stored procedure:

exec sp_helpdb

Which would yield some more extended information thus:


or if you just want the names, you could execute this “undocumented” stored procedure:

exec sp_msforeachdb 'print ''?'''

Which will yield this:


Or you could do the manual step of executing the following select query:

select name from sys.databases

Which will yield:




Step-by-Step – Installing the Microsoft Access Database Engine 2010 Redistributable

Written by Cornelius J. van Dyk on . Posted in How Do I...

This is a prerequisite to Installing PowerPivot for SharePoint into an EXISTING SharePoint Farm.  PowerPivot seems to work just fine being installed together with a clean install of SharePoint, but when you already have SharePoint installed and try to add PowerPivot… all hell breaks loose.  I was never able to find proper documentation on how to pull this off and managed to hack and debug my way through it like Holmes unraveling a mystery.  Hopefully this will save someone else some time and frustration…

  1. Logon to your server with the SharePoint service account.
  2. Download and run the appropriate setup package for the target version (x64 or x86) of your farm
  3. Click “Run” to execute the install package.
  4. image
  5. On the Welcome screen, click “Next”.
  6. image
  7. Check the “I accept the terms of the License Agreement” check box and click “Next” to continue.
  8. image
  9. Select the folder location to which you wish to install and finally click “Install”.
  10. image
  11. The installation should complete successfully.
  12. image



Latest Hyper-V VMs Available for Download

Written by Cornelius J. van Dyk on . Posted in Blog

Here’s a quick list of the lastest Hyper-V Virtual Machines available for download from Microsoft.  If you’re setting up a little private playground lab, this will save you tons of time and get you working out the latest and greatest software in a flash.

Start by grabbing the latest IW VM loaded with Office and SharePoint 2010 goodness: If you have Exchange cravings, satisfy them here: Want to throw OCS in the mix too?  Here you go: See how system health plays with all these: Of course, if you want to look at migration scenarios you could restore your restore you data to this VM and run an upgrade/migration: Lastly, if you want to just have the OS baseline and do all the other installs yourself, start here:  

Happy downloading!