Some SQL Server features do not work properly when installing DataKeeper on Windows Server 2008 R2 & SQL Server 2008

Description

When installing DataKeeper (or DataKeeper Cluster Edition) on Windows 2008 R2 & SQL Server 2008, some SQL Server features do not work properly due to the .NET Framework version. Perform each function to confirm that it is working properly.

Suggested Action

You can work around the problem by specifying the following .NET Framework version in the configuration file (*.exe.config) corresponding to the executable (*.exe) which is causing the error. If the configuration file does not exist, create it.

<configuration>
<startup>
<supportedRuntime version="v2.0.50727"/>
</startup>
</configuration>

Example:

For example, the following error occurs when executing SQLPS.exe.

C:\Users\sios>SQLPS.exe -Command dir
SQLPS failed to initialize: Could not loadtype 'Microsoft.PowerShell.Commands.FormatDefaultCommand' from assembly'Microsoft.PowerShell.Commands.Utility, Version=3.0.0.0, Culture=neutral,PublicKeyToken=31bf3856ad364e35'. 

Create a configuration file (SQLPS.exe.config) in the same directory where the executable (SQLPS.exe) is located and write the following:

‘C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\SQLPS.exe.config’

<configuration>
<startup>
<supportedRuntime version="v2.0.50727"/>
</startup>
</configuration>

Now you can execute the command successfully.

C:\Users\sios>SQLPS.exe -Command dir

Name            Root                           Description
----            ----                           -----------
SQL             SQLSERVER:\SQL                 SQL Server Database Engine
SQLPolicy       SQLSERVER:\SQLPolicy           SQL Server Policy Management
SQLRegistration SQLSERVER:\SQLRegistration     SQL Server Registrations
DataCollection  SQLSERVER:\DataCollection      SQL Server Data Collection
Utility         SQLSERVER:\Utility             SQL Server Utility
DAC             SQLSERVER:\DAC                 SQL Server Data-Tier Application Component